Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
restoring master database.. how to make an exclusive lock?
- Thread starter Linxs
- Start date
If you want to restore the master database you have to start it up in single mode from the command prompt.
sqlservr.exe -c -m
then you can restore it from within the query analyzer window if you have a valid backup. If you had a crash and it can't be recovered you should use the rebuild master utility.(Hope you don't have to though)
Everything's well described in the BOL
Just type 'restoring master database' in the index tab.
GL
Rosko
sqlservr.exe -c -m
then you can restore it from within the query analyzer window if you have a valid backup. If you had a crash and it can't be recovered you should use the rebuild master utility.(Hope you don't have to though)
Everything's well described in the BOL
Just type 'restoring master database' in the index tab.
GL
Rosko
- Status
Similar threads
- Locked
- Question
