Re: backup error - single user mode needed?
Tech-Archive recommends: Speed Up your PC by fixing your registry
- From: Richard Fagen <no_spam@xxxxxxx>
- Date: Wed, 27 Jul 2005 19:03:22 -0400
Hi Lyle,
Thanks for the article. Finally, a great explanation :)
Richard
Lyle wrote:
From Microsoft Article 290622:
BUG: Databse Manintenance Plan on System Databases faile on Intergrity
Check if "Attempt to repair minor problems" is Selected
... The database maintenance plan attempts to place the system databases
in the single user mode in order to execute CkDBRepair. However the
Master and MSDB databases cannot be placed in single user mode because of
constantly running system processes like LAZYWRITER, LOG WRITER, SQL
Agent... The repair step fails to run and the job reports a failure....
There is no fix for tis bug as yet. The workaround is to disable the
"Attempt to repair any minor problems" option in your maintenance plan.
Lyle
.
