You will still need to do all the references to the new system, so this is still valid once you update the system names.
System names will need to be updated in a number of spots just to get the AR Server started: plugin.server.xml (both AR and CMDB) ar.cfg armonitor.cfg Windows Registry ... then you can run the Restore Tool to do the rest of the references. I have done a couple of VM's this way renaming the actual server name - always forget to do the Registry. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sanford, Claire Sent: 31 October 2012 18:06 To: [email protected] Subject: Re: WWRUG12 - Session Question - Database Moving ** I need to be more clear. We copied the entire production server to a new development server. Not the best way to do it I KNOW! Not my decision. I have a new license key. The new Dev server is licensed. I have to know exactly where in the system I need to modify/change the old server references to the new server name. Server Name: ProdRemedy to Server Name: DevRemedy Config.properties Ar.cfg Etc. Server Name: ProdRemedy to Server Name: DevRemedy From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Carl Wilson Sent: Wednesday, October 31, 2012 1:01 PM To: [email protected] Subject: Re: WWRUG12 - Session Question - Database Moving ** 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"_ _attend WWRUG12 www.wwrug.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"
