May 18, 2012 at 4:05 am
I'm using the following command from the dos prompt to try to set an instance to single user mode but it doesn't work:
sqlservr.exe -m -s MACHINENAME\INSTANCENAME
What happens is the attached which obviously doesn't help me at all, and there are no errors or warnings in the Event Log.
It is SQL Server 2008 R2 SP1 that I'm using.
Anyone got any ideas?
May 18, 2012 at 4:23 am
Good error box!
Does this help? (From http://msdn.microsoft.com/en-us/library/ms162819.aspx)
"Important
When starting an instance of SQL Server, you must use the sqlservr application in the appropriate directory for that instance. For the default instance, run sqlservr from the \MSSQL\Binn directory. For a named instance, run sqlservr from the \MSSQL$instance_name\Binn directory."
May 18, 2012 at 4:26 am
Yeah, great error box isn't it !
Yes I'm running it from the Binn directory from the particular instance I'm testing with.
May 18, 2012 at 4:26 am
I don't think you need the machine name in there either.
May 18, 2012 at 4:32 am
Gazareth (5/18/2012)
I don't think you need the machine name in there either.
Haha, that was it! Well done! Thanks 🙂
May 18, 2012 at 4:33 am
No problem mate 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply