Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What is the best way to restore System database

Author  Topic 

tocroi72
Yak Posting Veteran

89 Posts

Posted - 2005-09-22 : 12:59:24
Hi,
I am wondering is there a way to restore Master database using T-SQL?
I restore user database using T-SQL succesfully but with Master database, for some reason i cann't do it.
Below is the list i do before trying to restore Master:

Run full backup of all databases(system + user db)
Stop SQL service completely
Restart SQL server in single user mode using Dos command (sqlservr.exe -c -m)
I have to do restore the master database from Enterprize manager. It doensn't let me to connect to the SQL analyzer to run T-SQL because
it is in Single Mode user.

I just try to practice backup/restore routine until i am confident of what to do in case of data failure. please give me recomendation for best way to restore Master database.
Thanks for any advice.



eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-09-22 : 15:34:40
system databases are handled differently. There is information in BOL about recovery of system databases.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp



-ec
Go to Top of Page
   

- Advertisement -