December 6, 2005 at 5:51 am
Hello, this is continued from yesterday, I was about to restore my user database, but I am having problems restoring the master.
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.
But when I go to put the Master db in single mode, the options are disabled?
Any Help?
Brian
December 6, 2005 at 6:12 am
What this requires is putting the server in single user mode. This can be done by the following proccess:
1. From Command Window, run NET STOP MSSQLServer.(If asked if you want to stop the related service SQLSERVERAGENT select yes).
2. Start up SQL Server in single user mode.
- Navigate to the directory where the SQL Server executable is located, for example C:\Program Files\Microsoft SQL Server\MSSQL\BINN\.
- Run the command sqlservr –m to put the server in single user mode.
3. Once this is done you can open query analyzer and execute your master database restore command.
December 6, 2005 at 6:42 am
how long should that take?
December 6, 2005 at 7:37 am
The whole process to restore the master database usually only takes a few minutes. If this is occuring on the same server that master was backed up from then that's all you should need to do. If however you are restoring the master database as part of a server migration or disaster recovery exercise then you will need to accomplish some other tasks as well. Such as restoring your user databases as well as the other system databases and the related work that goes along with that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply