January 2, 2007 at 11:37 am
I have a 64 bit Win2003 SQL Server 2005 SP1 third instance that I am attempting to test recovering the master database and I am having an issue. I startup master after navigating to the correct MSSQL.3 binn directory, open up command prompt and enter:
sqlservr.exe -c -m -s INST3 and SQL Server starts up Instance Three.
Open up another command prompt window and enter:
sqlcmd -E -d master -S INST3 -Q"restore database master from disk ='E:\master_backup_200701021308.bak'"
and it states it times out due to not in single user mode.....
What am I missing ???? I thought I had my documentation correct on this....
I have made sure that SQLServerAgent (inst3) is down as well....
Any help would be appreciated.
January 2, 2007 at 11:46 am
Make sure no one is in that instace...Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it.
Start the instance in single user mode...
http://msdn2.microsoft.com/en-us/library/ms345416.aspx
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
MohammedU
Microsoft SQL Server MVP
January 3, 2007 at 7:36 am
I figured out my problem. The -s is case sensitive and needs to be capitalized..
sqlcmd –E –S servername\INST3 –Q”restore database master from disk = ‘E:\backup\INST3\master_backup_200701021308.bak’”
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply