Hi Norm, Thanks for the quick information. We had been following the same method but on a non CMDB environment and it worked great.
However I wanted to ensure if this process holds good for restoring a DB with CMDB running. Do we have to follow any other steps to restore the CMDB apart from this normal db restore? Thanks, Mohan --- Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> wrote: > 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" > ____________________________________________________________________________________ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"