Sunday, February 19, 2012

DBCC CHECKDB Single User Mode

Does the database have to be in Single User Mode to execute the
statement listed below?
DBCC CHECKDB ('Database',Repair_Rebuild) WITH ALL_ERRORMSGS
Thanks,> Does the database have to be in Single User Mode to execute the
> statement listed below?
Based on the error message, I'd say yes'?
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.|||Yes it does. Before fixing any errors that checkdb has reported, you should
work out whay the errors occured (check the errorlog and event logs for
hardware messages for instance)
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AB - MVP" <ten.xoc@.dnartreb.noraa> wrote in message
news:OhQXkCNUFHA.3436@.TK2MSFTNGP09.phx.gbl...
> > Does the database have to be in Single User Mode to execute the
> > statement listed below?
> Based on the error message, I'd say yes'?
> Server: Msg 7919, Level 16, State 2, Line 1
> Repair statement not processed. Database needs to be in single user mode.
>

No comments:

Post a Comment