March 13, 2002 at 3:23 pm
When I try and restore the MS SQL Server 7 Master database I get and error about must be in single user mode..... How do I get to this mode... and/or get the Master Database restored using Enterprise Mgr.
Desperate !!!!!! Thanks!
March 13, 2002 at 6:12 pm
You have to right click on the database and then go to properties. Once in the properties window click onto the options tab and you will notice that the first option is to set the database into single user or dbo mode.
March 13, 2002 at 6:22 pm
To restore the master you have to start the server in Single User mode not just the database. See BOL "Restoring the master Database from a Current Backup" for details but just to start the server itself in single user mode do this.
From a command prompt, enter:
sqlservr.exe -c -m
Note You must switch to the appropriate directory (for the instance of Microsoft® SQL Server™ you want to start) in the command window before starting sqlservr.exe.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 13, 2002 at 6:56 pm
Also, you cannot use EM when you do this because it is looking for more than one connection. Use Query Analyzer and have your restore scripted.
If you get stuck, "shutdown" in T-SQl or CTRL-C from the command prompt will shut down sql
Steve Jones
March 14, 2002 at 9:41 am
quote:
To restore the master you have to start the server in Single User mode not just the database. See BOL "Restoring the master Database from a Current Backup" for details but just to start the server itself in single user mode do this.From a command prompt, enter:
sqlservr.exe -c -m
Note You must switch to the appropriate directory (for the instance of Microsoft® SQL Server™ you want to start) in the command window before starting sqlservr.exe.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 14, 2002 at 9:43 am
Thanks a lot for the help. I was able to get the mission accomplished!
March 14, 2002 at 9:54 am
Good to hear.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 17, 2002 at 6:01 am
I am trying this within a cluster , i am on the primary node and sqlserver.exe -c -m gives me, your sql server version is either corrupt or has been tampered with. But I can start sql up ok after that, maybe this is not possible within a cluster, any ideas
March 17, 2002 at 12:20 pm
Take a look here
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q298568
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply