Hi, I am running a maintenance plan daily, and under default configurations,
it's failing to Check data and index linkages on the "master" and "msdb"
database because it's not in single user mode. Am I not able to do this?
If so, do I need to change it to single user? Will that harm anything else?
_____
DC GIt's failing because you've set the job up to automatically repair minor
errors. You should not do this - always investigate integrity problems
before taking any corrective action (i.e. restoring from your backups)
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"DC Gringo" <glevine@.visiontechnology.net> wrote in message
news:ueA0bX0lDHA.1244@.TK2MSFTNGP11.phx.gbl...
> Hi, I am running a maintenance plan daily, and under default
configurations,
> it's failing to Check data and index linkages on the "master" and "msdb"
> database because it's not in single user mode. Am I not able to do this?
> If so, do I need to change it to single user? Will that harm anything
else?
> _____
> DC G
>
No comments:
Post a Comment