Friday, February 24, 2012

DB Maintenance Plan - integrity check

Hi:
After I selected "Attemp to repair any minor problems",
my integrity check failed. - "Repair statement not
processed. Database needs to be in single user mode" for
Master and msdb.
How do I change to single user mode from within
Maintenance Plan?
Thanks in advance.You don't - just deselect the option to repair. It's
probably better to just monitor the DBCC statements and if
there are errors, intervene yourself, track down the issues,
make sure there aren't any hardware problems, etc.
-Sue
On Mon, 22 Sep 2003 11:03:43 -0700, "Dave K."
<uk@.hotmail.com> wrote:
>Hi:
>After I selected "Attemp to repair any minor problems",
>my integrity check failed. - "Repair statement not
>processed. Database needs to be in single user mode" for
>Master and msdb.
>How do I change to single user mode from within
>Maintenance Plan?
>Thanks in advance.

No comments:

Post a Comment