BUG: Database maintenance plan on system databases fails on integrity check if "Attempt to repair minor problems" is selected

When the Attempt to repair any minor problems option is enabled, a database maintenance plan may fail when you run integrity checks on all the system databases and you receive the following error message:

The database maintenance plan tries to put the system databases in the single-user mode in order to execute -CkDBRepair. However, the master and msdb databases cannot be put in single-user mode because of constantly running system processes such as LAZYWRITER, LOG WRITER, CHECKPOINT, SQLAgent and Generic Refresher. The repair step fails to run, and therefore the job reports a failure.

Note This problem is not limited to system databases. It also occurs with user databases if users are connected to the databases when the maintenance plan tries to set the database to single-user mode.

Disable the Attempt to repair any minor problems option. To do this, follow these steps in the SQL Server Enterprise Manager:

1. Right-click and select Properties on the Database Maintenance plan.
2. Click the Integrity tab.
3. Click to clear the Attempt to repair any minor problems check box under Check Database Integrity.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.