December 11, 2010 at 8:42 am
I am trying to stat the server in single user mode for DR test. i need to restore the master database. I am entering command
sqlservr.exe -c –m -s instancename
When I do this the server does start but when I attempt the restore it says I am not in single user mode. I have verified this because I can open multiple SSMS connections to the server. I have some documentation form last years test and the SQL log gives a warning it is starting in single user mode just before starting the master database. I a not getting that message today.
Last year it also gave a message that Database Mirroring Transport was disabled but this year it states Database Mirroring has been enabled. I am not sure if this is significant or just a coincidence. Any help would be appreciated.
December 11, 2010 at 10:25 am
Please check if there is another instance of sqlservr.exe running in Task Manager.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 11, 2010 at 11:00 am
I did get by the problem for now by going to services, doing properties on SQL Server and putting the -m start up parm and starting it. Next week I will do some more testing and I will definitely check that possibility. Thanks for your reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply