March 31, 2005 at 10:13 am
horror of all horrors, the master database for sqlserver 7.0 got hosed. i am trying to restore it, but i have to restart sql server in single user mode. i have tried doing this via, command prompt, no success, cant use EM, the option is disabled. HELP!!!!!!!!!!
[font="Comic Sans MS"][/font]It is what it is.
March 31, 2005 at 10:33 am
sqlservr.exe -c -m ( from the appropriate directory )
use master
go
restore database master from tape = '\\.Tape0'
from disk file='xxxx.bak'
It's in BOL - just follow the instructions.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 31, 2005 at 10:37 am
will do , thanks
[font="Comic Sans MS"][/font]It is what it is.
March 31, 2005 at 1:38 pm
If you're still unable to start SQL (due to the corrupt master), have a look at "Rebuild Master" in Books Online. There is a utility that will rebuild master to what it was originally. Then, after its rebuilt, you should be able to start SQL in single user mode, and restore master from a backup.
Steve
April 1, 2005 at 5:12 am
i was able to restore the master database, the problem was that after i did this, i used the "sqlservr.exe " , so that i could restore the other databases, and i restarted the server using mssql service, i was the only one that could log into the the web application using that database, was ther an explicit command that i needed to give to take it out of single user mode?
[font="Comic Sans MS"][/font]It is what it is.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply