Article ID: 264154 - View products that this article applies to.
This article was previously published under Q264154
The correct way to run a DBCC CHECKDB or DBCC CHECKTABLE statement with valid REPAIR options is to start SQL Server normally and then explicitly set the database in single user mode. You can do this from either the Enterprise Manager or the Query Analyzer.
From Enterprise Manager:
After the database is in single user mode, you can then run the DBCC CHECKDB or DBCC CHECKTABLE statements with the valid REPAIR options.
If you are using SQL Server 2005For more information about how to start SQL Server in single-user mode, visit the following Microsoft Developer Network (MSDN) Web site:
If you start SQL Server in single user mode (by using -m) and then you run a DBCC CHECK statement (CHECKDB or CHECKTABLE) with one of the valid REPAIR options, SQL Server generates this error message:
The preceding error message corresponds to error number 7919.
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your
The following example illustrates the problem:
This behavior is by design. When you start SQL Server in single user mode, you do not explicitly set the status of each database in single user mode. You only do that for the Master database. However, the DBCC CHECK statement checks the status for that specific database on which it is being run and if it is not set to single user the error message occurs.
Article ID: 264154 - Last Review: February 22, 2007 - Revision: 4.3