May 15, 2006 at 8:32 am
I have installed SQL 2005 with SP1 on a dev server. I have backed up the master db and am trying to play around with recovering the master db from a backup. I open cmd prompt and navigate to the sqlservr.exe and run sqlservr.exe -c -m like BOL says, starts fine. Then I attempt to goto NEW QUERY in Mgt. studio and run a restore database master from ... and give the location of the master db backup. It says that db has another connection to it so I cannot recover master.....
Does anyone have any ideas on what this and how I get around this problem. This is a DEV box and there is no apps even know about this SQL Server....
May 15, 2006 at 10:22 am
I think that the query and MS have their own connections each. Try to use sqlcmd command-prompt utility which is very similar to osql to run your query
Another option is to right-click on your server in object explorer and select Disconnect
Regards,Yelena Varsha
May 15, 2006 at 11:03 am
OK, I started it in single user mode again and did the SQLCMD utility and it says the same thing. Restore failed due to SQL Server not in single user mode....
May 15, 2006 at 2:48 pm
Did you double check surface area configuration to insure that no other services are running?
May 15, 2006 at 2:51 pm
Also, you may encounter version problems if you don't have sp1 on the the server that your backup came from.
May 15, 2006 at 3:00 pm
Curtis is totally correct. It may be Agent that polls every several seconds.
Regards,Yelena Varsha
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply