December 9, 2002 at 5:48 am
When I got into work this monday morning, I found one database on one of our SQL servers in Single User mode.
I stopped and started the SQL server, and from QA ran the following command
exec sp_dboption 'mydatabase', 'single user', 'false'
and the system ran fine from there. The question is :
How did it end up in "Single User" mode?
Kind regards
Henrik Staun Poulsen
Stovi Software
December 9, 2002 at 6:12 am
Used to be a bug in the maintenance plans that could cause it, if you checked the repair minor errors option. Fixed in a service pack. DBCC has to have exclusive access to do the fix, would not set it back sometimes.
Andy
December 9, 2002 at 6:25 am
If you have maintenance plans they should tell you if they set a db to single user.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply