Re: backup error - single user mode needed?

>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

In article <O3JolEukFHA.2792@xxxxxxxxxxxxxxxxxxxx>, no_spam@xxxxxxx
says...
> Hi Everyone,
>
> One of my clients is running SQL 2000 SP4 and the Data Maintenance Plan
> logs shows a log with...
>
> ----
>
> Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
>
> The following errors were found:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> ...
>
> [5] Database master: Database Backup...
>
> The backup was not performed since data verification errors were found.
>
>
> -----
>
> There are similar messages for databases model and msdb.
>
> Questions:
> - should master, model and msdb be included in the daily backup?
> - how does one get into single user mode and repair this?
>
> Thanks
>
> Richard
>
.