April 26, 2010 at 10:52 am
Please suggest me to method to start the mssql 2005 instance back in multi-user mode.
i ran the instance in single user mode and now wondering how to start it back in multi-user mode.
April 26, 2010 at 11:17 am
USE [master]
GO
ALTER DATABASE [<Your DB Name>] SET READ_WRITE WITH NO_WAIT
Is that what you are looking for?
-- Cory
April 26, 2010 at 11:28 am
NEW TO SQL (4/26/2010)
Please suggest me to method to start the mssql 2005 instance back in multi-user mode.i ran the instance in single user mode and now wondering how to start it back in multi-user mode.
Are you referring to a single database or the complete SQL instance <server level>?
If you are referring to database...reference what Cory posted.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 26, 2010 at 11:31 am
good catch, I missed the "instance" key word. 😀
-- Cory
April 26, 2010 at 11:59 am
Yes, want it for an Instance.
April 26, 2010 at 12:05 pm
How did you put it in single user mode?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 26, 2010 at 12:30 pm
from command prompt..
i went to that instance and then ran sqlservr.exe -m -s<instancename>
April 26, 2010 at 12:34 pm
NEW TO SQL (4/26/2010)
from command prompt..i went to that instance and then ran sqlservr.exe -m -s<instancename>
just a hunch, stop the service (ctl break if the window is still up, or task manager) and then remove the -m
-- Cory
April 26, 2010 at 12:51 pm
Cory would be correct.
You will break that session (CTRL + C) and close that command prompt window. Then just start services back using the SQL Configuration Manager console.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply