I would also run a stored procedure to find and replace all occurrences of the production servername once you make the move.
I found the stored procedure on this site to be helpful with that: http://vyaskn.tripod.com/sql_server_search_and_replace.htm Just be careful because if that server is in Asset Management or referenced in tickets, you might overwrite it. I get around by using FQDN's instead of the simple server name, so I can find and replace the entire string only. Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, August 06, 2007 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Database restore from Production server to Newly built Test Server Simple. The only complication is that you'll need to momentarily stop the MS SQL service on the production server for a few minutes (which, consequently, will cause Remedy to stop as well). Once the service is stopped, go to the Data folder inside the MSSQL folder. Copy the ARSystem MDF and LDF files onto some portable media. If they're big files, you might have to burn them to CD. Go to the test server and open Microsoft SQL Enterprise Manager, detach the Remedy database. Rename the ARSystem.mdf and ARSystem.ldf files something else. Put the CD in the test server and copy the files from the CD to the same exact location on the test server. >From Enterprise Manager, attach the database. Restart the services. You should be working now. Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath Sent: Monday, August 06, 2007 12:28 PM To: arslist@ARSLIST.ORG Subject: Database restore from Production server to Newly built Test Server Hi All, We have built a new physical test AR Server with exactly the same configuration as Production server and the same type of OS and database . We have the following suite of Remedy Products installed in our new test environment which is also exactly the same as our production environment. AR Server version 7.0.00 Patch 002 200610161323. The CMDB version is 1.1.0 patch 003. The Asset management version is 6.0. patch 1413. HelpDesk version 6.0 Database: Microsoft SQL-Server 2000 We want to restore the production database to this newly built test server and need guidelines/process to do a restore on the test server which currently just has the data and the workflow objects from the fresh application installation. So can you please provide instructions with any precautions (general aswell CMDB specific ) to do a database restore from Production to newly built Test server? Thanks, Mohan ________________________________________________________________________ ____________ Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Private and confidential as detailed <a href="http://www.sug.com/disclaimers/default.htm#Mail";>here</a>. If you cannot access hyperlink, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
