Errors below are displayed when adding the "Integrity" step to a maintenance plan and including "Attempt to repair...":
"Option 'SINGLE_USER' cannot be set in database 'MASTER'. Repair statement not processed. Database needs to be in single user mode.
Error may display as Error 50000, Severity Level 19
Option 'SINGLE_USER' cannot be set in database 'MASTER'. Repair statement not processed. Database needs to be in single user mode.
State cannot be changed while other users are using the database 'msdb'
ALTER DATABASE statement failed.
Repair statement not processed. Database needs to be in single user mode."
DBCC CHECKDB validates the integrity of everything in a database and it finds the errors. The given database_name must be in single-user mode to use a repair option and can be one of the following: REPAIR_ALLOW_DATA_LOSS, REPAIR_FAST (included on the LiteSpeed GUI for Maintenance Plans) and REPAIR_REBUILD.
Schedule maintenance period to take the system databases to single user mode and then run the integrity checks and repairs separate from the maintenance plans for backup.
For additional info, see: http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx
