Optimization and Integrity Error

Is there any way to run an optimization and integrity check against the
master and msdb databases? Below are the log files. Thanks!
- Gabe
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
Starting maintenance plan 'System Databases - Optimizations and Integrity'
on 6/2/2007 2:00:01 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] 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 **
[2] Database model: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'msdb'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[3] Database msdb: 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 **
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'System Databases - Optimizations and Integrity' on
6/2/2007 2:00:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Gabe,
Sure, but you need to turn off the "repair minor problems" option.
http://support.microsoft.com/kb/290622
RLF
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
> Is there any way to run an optimization and integrity check against the
> master and msdb databases? Below are the log files. Thanks!
> - Gabe
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
> Starting maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
> database 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] 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 **
> [2] Database model: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while other
> users are using the database 'msdb'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [3] Database msdb: 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 **
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>|||Thanks!!
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23qevkq6pHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Gabe,
> Sure, but you need to turn off the "repair minor problems" option.
> http://support.microsoft.com/kb/290622
> RLF
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to run an optimization and integrity check against the
>> master and msdb databases? Below are the log files. Thanks!
>> - Gabe
>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
>> 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
>> Starting maintenance plan 'System Databases - Optimizations and
>> Integrity' on 6/2/2007 2:00:01 AM
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
>> database 'MASTER'.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [1] 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 **
>> [2] Database model: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'msdb'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [3] Database msdb: 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 **
>> Deleting old text reports... 0 file(s) deleted.
>> End of maintenance plan 'System Databases - Optimizations and Integrity'
>> on 6/2/2007 2:00:01 AM
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>