SQL2000 SP3 master db restore failing even when in single user mode using sqlservr.exe -c -m
Posted on 2009-07-07
I'm struggling to do a master DB restore from backup. I've done before so not sure why this box is a problem. I've stopped SQL, SQL Agent & Report Server services. Started SQL in single user mode using sqlservr.exe -c -m, opened only query analyzer as sa (no object browser) and run the query:
RESTORE DATABASE master FROM DISK = 'c:\master_db_200907020100.BAK'
but I still recieve:
Server: Msg 3108, Level 16, State 1, Line 1
RESTORE DATABASE must be used in single user mode when trying to restore the master database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I'm certain the database is in single user mode and I've stopped all services that I can possibly think of that may be accessing SQL in some way.
I've also run an sp_who and there are 16 spids, but they are all sa.
Anyone got any ideas? Thanks in advance.