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.
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 completelyRestart 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 |
|
|
|
|