We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration
Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. > Date: Wed, 31 Oct 2012 17:30:37 +0000 > From: claire.sanf...@memorialhermann.org > Subject: Re: WWRUG12 - Session Question - Database Moving > To: arslist@ARSLIST.ORG > > My new management team had the Network Admin team copied the Prod Server as a > whole to the Dev Server. They wanted the environments to be identical in > every way. The problem is that they are not. I have fixed things in many > places, but am sure there is something I am missing because the performance > is terrible. > > The DBA team copied the Database over and I think I have that all sorted out > as well... I have fixed things in many places, but am sure there is something > I am missing because the performance is terrible. > > They want to do this again and at WWRUG in of the sessions the speaker > mentioned a list at the end of his presentation. I can't find the note where > I wrote down which session it was and I THINK I have gone through every > presentation on the thumb drive. > > > So this is basically what management called "P to V" copying. Physical to > Virtual. > > I will take any list anyone has at this time. I will compile it all into one > list in combination with what I have already noted that I changed. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron > Sent: Wednesday, October 31, 2012 12:22 PM > To: arslist@ARSLIST.ORG > Subject: Re: WWRUG12 - Session Question - Database Moving > > I wasn't there this year but to clarify your question, are you asking about > copying the database server or database or something else and copying it to > another server? We do something similar to refresh our non-prod environments > with the production database. I came up with the process and it may not be > exhaustive, but we haven't had any issues with it. Let me know if you're > interested. > > Ron > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire > Sent: Wednesday, October 31, 2012 8:26 AM > To: arslist@ARSLIST.ORG > Subject: WWRUG12 - Session Question - Database Moving > > I have drawn a complete blank and in my 97 pages of notes (yes, I took notes > in a notebook) from WWRUG12 I can't find what I am looking for. > > In one of the sessions there was some discussion regarding taking one server > and copying it to another server. It is not recommended but whoever was doing > the presentation said that he (I do remember it was a he) had the steps at > the end of the presentation or would send them (not sure here) for the 7 or 8 > things that MUST be modified to make the new server function properly. > > We did that here and while things look like they are working properly, we are > getting a lot of DB timeouts and the performance is very slow. > > Does anyone know what presentation I am talking about? Does anyone have those > specific steps? > > > ITSM 7.6.04 SP2 > ARS 7.6.04 SP3 > Oracle 11.2.0.3.0 - 64bit Production > Win 2008 Server > > Claire Sanford > Information Systems Division > Memorial Hermann Healthcare System > claire.sanf...@memorialhermann.org > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
