Master database locations are taken from the startup arguments. It's pretty easy, I've had to do it many times. This KB will help you out. As long as you have a good backup strategy, restores are relatively painless.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071 jr -----Original Message----- From: julian brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 11:36 AM To: MSWinNT Discussions Subject: OT SQL All Scenario: I have just restored an SQL server System partition, and I have the directory structure for the data partition (Lets assume there is a system C: and a data D:). I have the master.mdb, and the master.ldf files and I wish to use these files in my DR scenario. is there a script I can use to activate these files as the Master Database or is there another way of restoring the DB in this scnario. Assistance here would be appreciated as I have to give a presentation to the IT management ths week on the proposed DR strategy. Regards Julian _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED] ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
