Hi, or you can do it the easy way using this free utility:
http://www.missingpiecessoftware.com/products/remedy-restore-tool If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of ravi rai Sent: 31 October 2012 17:49 To: [email protected] Subject: Re: WWRUG12 - Session Question - Database Moving ** 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: [email protected] > Subject: Re: WWRUG12 - Session Question - Database Moving > To: [email protected] > > 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:[email protected]] On Behalf Of Peters, Ron > Sent: Wednesday, October 31, 2012 12:22 PM > To: [email protected] > 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:[email protected]] On Behalf Of Sanford, Claire > Sent: Wednesday, October 31, 2012 8:26 AM > To: [email protected] > 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 > [email protected] > > > > ____________________________________________________________________________ ___ > 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" _attend WWRUG12 www.wwrug.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"
