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)
>>
>

Operations Master Question

At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>

Operations Master Question

At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.Um, this is a SQL Server newsgroup. You may want to try one of the Windows
newsgroups.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Preacher Man" <nospam> wrote in message
news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
At one of our locations I current have two domain controllers. One of which
serves as the RID and the Infrastructure, the other serves as my PDC. The
first PC also runs WINS and DNS.
Because of some new software that needs to be installed on a Non-DC server I
need to demote PC #2 to a member server.
So here's my question. Does my memory serve me correctly in thinking that I
cannot move the PDC operation to PC #1? I remember something of this sort,
but I can't remember the details.
Thanks.|||Oops Sorry.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eVdSMsZXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Um, this is a SQL Server newsgroup. You may want to try one of the
> Windows
> newsgroups.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Preacher Man" <nospam> wrote in message
> news:%23ltHePZXGHA.1352@.TK2MSFTNGP05.phx.gbl...
> At one of our locations I current have two domain controllers. One of
> which
> serves as the RID and the Infrastructure, the other serves as my PDC. The
> first PC also runs WINS and DNS.
> Because of some new software that needs to be installed on a Non-DC server
> I
> need to demote PC #2 to a member server.
> So here's my question. Does my memory serve me correctly in thinking that
> I
> cannot move the PDC operation to PC #1? I remember something of this
> sort,
> but I can't remember the details.
> Thanks.
>