Home Forums SQL Server 2005 Administering Getting SQL Server 2005 Database out of Single-User Mode RE: Getting SQL Server 2005 Database out of Single-User Mode

  • Yes, that will usually work better.  But you still have to be prepare to lookup and kill a connection that might have snuck in. 

    This was the problem with SQL Server 2000 maintenance plans, where some would unknowningly check the box for "automatically fix minor errors" under the "Check database for errors" options.  For SQL server to fix errors, it had to put the database in single user mode.  If the database was busy at the time, sometimes a user would be able to get in between the Alter database and DBCC CheckDB commands and grab single-user control, killing the job, and blocking out all other users.  As a consultant, I have been called to several sites that have had this problem.  Then they feel plenty bad about paying me $160/hour w/4hr minimum for me to come in and uncheck a check box.



    Mark