Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered

We are using sql server 2005 Enterprise Edition with service pack1

I got the following error messages in the SQL log

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log

Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required.

Can anyone please help me in troubleshooting this issue. Why this migh have happened.

any help would be appreciated.

Thanks

This sounds like an IO subsystem issue, i.e. SQL Server is having difficulty talking to one of your drives. Are you using direct attached storage or a SAN?|||

Thanks for the reply. We have Netapp SCSI disk storage. Could you please tell me how do I troubleshoot this so that I wont get such errors in future.

Thanks

|||Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call.|||

Do read this kb before contacting PSS. You might be running on an unsupported device.

http://support.microsoft.com/kb/304261

Error: Event id: 208 @ Copy Database Wizard

Can anyone help me?

When i Use the copy database wizard @.sql 2005 at the last step

i get these 2 Error's in the log's

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 14-8-2006
Time: 13:28:40
User: N/A
Computer: SERVER01

Description:
SQL Server Scheduled Job 'CDW_NAME_0' (0x883C948F64FCAA49BEA22068F4C7E15A) - Status: Failed - Invoked on: 2006-08-14 13:28:19 - Message: The job failed. The Job was invoked by User Domain\Administrator. The last step to run was step 1 (CDW_NAME_0_Step).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date: 14-8-2006
Time: 13:28:40
User: Domain\Administrator
Computer: SERVER01
Description:
Package "CDW_NAME_0" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have the same error on SQL 2005 enterprise, am trying to copy a 2000 database into 2005. Should work but fails on copy.|||

I'm moving this over to the tools forum since they have more experience with CDW.

Thanks,
Sam

|||DID YOU FIND ANYTHING ON THIS PROBLEM|||

what is the service pack on this box. You should apply SP2 and also check whether SSIS (Integration Service) is installed or not

Madhu

|||THERE IS SP2 AND THE INTEGRATION SERVICE IS STARTED AS ADMNISTRATOR

Error: Event id: 208 @ Copy Database Wizard

Can anyone help me?

When i Use the copy database wizard @.sql 2005 at the last step

i get these 2 Error's in the log's

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 14-8-2006
Time: 13:28:40
User: N/A
Computer: SERVER01

Description:
SQL Server Scheduled Job 'CDW_NAME_0' (0x883C948F64FCAA49BEA22068F4C7E15A) - Status: Failed - Invoked on: 2006-08-14 13:28:19 - Message: The job failed. The Job was invoked by User Domain\Administrator. The last step to run was step 1 (CDW_NAME_0_Step).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date: 14-8-2006
Time: 13:28:40
User: Domain\Administrator
Computer: SERVER01
Description:
Package "CDW_NAME_0" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have the same error on SQL 2005 enterprise, am trying to copy a 2000 database into 2005. Should work but fails on copy.|||

I'm moving this over to the tools forum since they have more experience with CDW.

Thanks,
Sam

|||DID YOU FIND ANYTHING ON THIS PROBLEM|||

what is the service pack on this box. You should apply SP2 and also check whether SSIS (Integration Service) is installed or not

Madhu

|||THERE IS SP2 AND THE INTEGRATION SERVICE IS STARTED AS ADMNISTRATORsql

Error: Backup Log terminating abnormally

hi
i am using sql server 2000. when i try to backup log file it throws out the following error and hence the second command that is dbcc shrinkfile never gets executed. if i restart sql server and re-run these commands ... no error pops up ... both the comma
nds get completed sccessfully and log file gets shrunk too.
these are the commands that i run
BACKUP LOG BAMPrimaryImport WITH TRUNCATE_ONLY
DBCC SHRINKFILE ( BAMPrimaryImport_log, 500 )
this is the error that i get
Server: Msg 3023, Level 16, State 3, Line 1
Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
I am quite sure that no other command is active at the time when i issue these commands, still i get error. any help will be appreciated.
regards
yashrah.
Hi
Can you check your SQL Error log for the message when this command failed,
also can you please provide the SQL Server 2000 Service pack level.
you can get the Service pack level by running select @.@.version from query
analyzer.
Also, do you have replication set up, if yes, what kind of replication?
3023 means, It thinks there is some concurrent database operation going on
that is blocking the ALTER DATABASE, because it is unable to acquire the
database lock.
Regards
Sadeesh
This posting is provided AS IS with no warranties, and confers no rights.
"Yashrah [Xavor]" <YashrahXavor@.discussions.microsoft.com> wrote in message
news:73E811CE-FCBF-4D29-9538-6D22F842A8EC@.microsoft.com...
> hi
> i am using sql server 2000. when i try to backup log file it throws out
> the following error and hence the second command that is dbcc shrinkfile
> never gets executed. if i restart sql server and re-run these commands ...
> no error pops up ... both the commands get completed sccessfully and log
> file gets shrunk too.
> these are the commands that i run
> BACKUP LOG BAMPrimaryImport WITH TRUNCATE_ONLY
> DBCC SHRINKFILE ( BAMPrimaryImport_log, 500 )
> this is the error that i get
> Server: Msg 3023, Level 16, State 3, Line 1
> Backup and file manipulation operations (such as ALTER DATABASE ADD FILE)
> on a database must be serialized. Reissue the statement after the current
> backup or file manipulation operation is completed.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP LOG is terminating abnormally.
> I am quite sure that no other command is active at the time when i issue
> these commands, still i get error. any help will be appreciated.
> regards
> yashrah.
|||thanx for ur concern...
SQL Error Log says
2004-07-22 02:40:23.10 backup BACKUP failed to complete the command exec shrink_bamprimaryimport_logfile
infact "shrink_bamprimaryimport_logfile" is my stored procedure that contains the two commands (backup log and dbcc shrinkfile) written below.
servie pack 3a is installed and no replication set up is there.
"Sadeesh[MSFT]" wrote:

> Hi
> Can you check your SQL Error log for the message when this command failed,
> also can you please provide the SQL Server 2000 Service pack level.
> you can get the Service pack level by running select @.@.version from query
> analyzer.
> Also, do you have replication set up, if yes, what kind of replication?
> 3023 means, It thinks there is some concurrent database operation going on
> that is blocking the ALTER DATABASE, because it is unable to acquire the
> database lock.
> Regards
> Sadeesh
> --
> This posting is provided AS IS with no warranties, and confers no rights.
> "Yashrah [Xavor]" <YashrahXavor@.discussions.microsoft.com> wrote in message
> news:73E811CE-FCBF-4D29-9538-6D22F842A8EC@.microsoft.com...
>
>

Error: Backup Log terminating abnormally

hi
i am using sql server 2000. when i try to backup log file it throws out the
following error and hence the second command that is dbcc shrinkfile never g
ets executed. if i restart sql server and re-run these commands ... no error
pops up ... both the comma
nds get completed sccessfully and log file gets shrunk too.
these are the commands that i run
BACKUP LOG BAMPrimaryImport WITH TRUNCATE_ONLY
DBCC SHRINKFILE ( BAMPrimaryImport_log, 500 )
this is the error that i get
Server: Msg 3023, Level 16, State 3, Line 1
Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on
a database must be serialized. Reissue the statement after the current back
up or file manipulation operation is completed.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
I am quite sure that no other command is active at the time when i issue the
se commands, still i get error. any help will be appreciated.
regards
yashrah.Hi
Can you check your SQL Error log for the message when this command failed,
also can you please provide the SQL Server 2000 Service pack level.
you can get the Service pack level by running select @.@.version from query
analyzer.
Also, do you have replication set up, if yes, what kind of replication?
3023 means, It thinks there is some concurrent database operation going on
that is blocking the ALTER DATABASE, because it is unable to acquire the
database lock.
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Yashrah [Xavor]" <YashrahXavor@.discussions.microsoft.com> wrote in mess
age
news:73E811CE-FCBF-4D29-9538-6D22F842A8EC@.microsoft.com...
> hi
> i am using sql server 2000. when i try to backup log file it throws out
> the following error and hence the second command that is dbcc shrinkfile
> never gets executed. if i restart sql server and re-run these commands ...
> no error pops up ... both the commands get completed sccessfully and log
> file gets shrunk too.
> these are the commands that i run
> BACKUP LOG BAMPrimaryImport WITH TRUNCATE_ONLY
> DBCC SHRINKFILE ( BAMPrimaryImport_log, 500 )
> this is the error that i get
> Server: Msg 3023, Level 16, State 3, Line 1
> Backup and file manipulation operations (such as ALTER DATABASE ADD FILE)
> on a database must be serialized. Reissue the statement after the current
> backup or file manipulation operation is completed.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP LOG is terminating abnormally.
> I am quite sure that no other command is active at the time when i issue
> these commands, still i get error. any help will be appreciated.
> regards
> yashrah.|||thanx for ur concern...
SQL Error Log says
2004-07-22 02:40:23.10 backup BACKUP failed to complete the command exec
shrink_bamprimaryimport_logfile
infact "shrink_bamprimaryimport_logfile" is my stored procedure that contain
s the two commands (backup log and dbcc shrinkfile) written below.
servie pack 3a is installed and no replication set up is there.
"Sadeesh[MSFT]" wrote:

> Hi
> Can you check your SQL Error log for the message when this command failed,
> also can you please provide the SQL Server 2000 Service pack level.
> you can get the Service pack level by running select @.@.version from query
> analyzer.
> Also, do you have replication set up, if yes, what kind of replication?
> 3023 means, It thinks there is some concurrent database operation going on
> that is blocking the ALTER DATABASE, because it is unable to acquire the
> database lock.
> Regards
> Sadeesh
> --
> This posting is provided AS IS with no warranties, and confers no rights.
> "Yashrah [Xavor]" <YashrahXavor@.discussions.microsoft.com> wrote in me
ssage
> news:73E811CE-FCBF-4D29-9538-6D22F842A8EC@.microsoft.com...
>
>sql

Error: 7105, Severity: 22, State: 6

My SQL server logs this in Application log:
Error: 7105, Severity: 22, State: 6
Page (1:952446), slot 39 for text, ntext, or image node does not exist.
MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS for
a hot fix for this problem.
I believe this call is free because this is a bug. Can anyone confirm this?
Thanks.Oops.
Wrong group.
"ME" <ME@.mail.com> wrote in message
news:e7fZBsT$GHA.4800@.TK2MSFTNGP05.phx.gbl...
> My SQL server logs this in Application log:
> Error: 7105, Severity: 22, State: 6
> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
> for a hot fix for this problem.
> I believe this call is free because this is a bug. Can anyone confirm
> this? Thanks.
>
>sql

Error: 7105, Severity: 22, State: 6

My SQL server logs this in Application log:
Error: 7105, Severity: 22, State: 6
Page (1:952446), slot 39 for text, ntext, or image node does not exist.
MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS for
a hot fix for this problem.
I believe this call is free because this is a bug. Can anyone confirm this?
Thanks.Make the call, they will tell you up front if it will be a covered (free)
call.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ME" <ME@.mail.com> wrote in message
news:%23OovmtT$GHA.3344@.TK2MSFTNGP03.phx.gbl...
> My SQL server logs this in Application log:
> Error: 7105, Severity: 22, State: 6
> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
> for
> a hot fix for this problem.
> I believe this call is free because this is a bug. Can anyone confirm
> this?
> Thanks.
>|||Hotfix calls are always free. Issues that are determined to be bugs are
free, even if no hotfix yet exists.
If you call the 800 number with the KB article # ready, tell them you are
looking for the hotfix, they will code it as "professional unpaid" and
transfer you to the support engineer.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eepBp5T$GHA.1760@.TK2MSFTNGP02.phx.gbl...
> Make the call, they will tell you up front if it will be a covered (free)
> call.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "ME" <ME@.mail.com> wrote in message
> news:%23OovmtT$GHA.3344@.TK2MSFTNGP03.phx.gbl...
>> My SQL server logs this in Application log:
>> Error: 7105, Severity: 22, State: 6
>> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
>> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
>> for
>> a hot fix for this problem.
>> I believe this call is free because this is a bug. Can anyone confirm
>> this?
>> Thanks.
>>
>

Error: 66030

Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
>> Hi,
>> On one of our SQL 2000 cluster servers we have been
>> getting a lot of error messages in our SQL Server log
ile.
>> Error: 66030, Severity: 15, State: 1
>> Occasionally it also reports
>> Error: 66040, Severity: 15, State: 1.
>> I have been unable to find any information on these
error
>> messages. I would be grateful if someone could shed
some
>> light on what these messages actually mean. Thanks.
>
>.
>sql

Error: 66030

Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.

>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some[vbcol=seagreen]
>
>.
>

Error: 66030

Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.
The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>
|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.

>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some
>
>.
>

Error: 644, Severity: 21, State: 3

I am getting these errors in my event log pertaining to the MSDB
database. I don't have any backups so I can't restore. Can't I just
recreate the system databases? What implications will that cause?
Here's the dbcc checkdb output from QA.
Any insight would be helpful.
Andy
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 394 rows in 8 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 241 rows in 11 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3468 rows in 123 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 402 rows in 163 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 185 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 17 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2567 rows in 17 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 4 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
reference from previous page (1:3505). Possible chain linkage problem.
There are 1189 rows in 6 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 28046 rows in 460 pages for object 'backupfile'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupfile' (object ID 18099105).
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 54 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2333 rows in 22 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 96 rows in 1 pages for object 'restorefile'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'RTblParameterDef'.
There are 136 rows in 2 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 42 rows in 1 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3349 rows in 12 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2196 rows in 15 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
(sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68528).
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'sysdbmaintplans'.
There are 2 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 1 rows in 1 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
(sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68529).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
(sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68530).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
(sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68531).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
(sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68532).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
(sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68533).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
(sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68534).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
(sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68535).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
(sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68536).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
(sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68537).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
(sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68538).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
(sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68539).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
(sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68540).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
(sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68541).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
(sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68542).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
(sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68543).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
(sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68544).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
(sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68545).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
(sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68546).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
(sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68547).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
(sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68548).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
(sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68549).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
(sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68550).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
(sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68551).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
(sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68552).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
(sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68553).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
(sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68554).
There are 1000 rows in 41 pages for object 'sysdbmaintplan_history'.
CHECKDB found 0 allocation errors and 27 consistency errors in table
'sysdbmaintplan_history' (object ID 1090102924).
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'RTblVersions'.
There are 2333 rows in 20 pages for object 'RTblVersions'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6922 rows in 97 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 44 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 393 rows in 2 pages for object 'RTblProps'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index
'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1542:26) with values (media_family_id =
124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
family_sequence_number = 1.499725856E-305) points to the data row
identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
There are 797 rows in 7 pages for object 'RTblPropDefs'.
DBCC results for 'RTblClassExtension'.
There are 69 rows in 1 pages for object 'RTblClassExtension'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 2 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 453 rows in 4 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 24118 rows in 249 pages for object 'backupmediaset'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
There are 24118 rows in 459 pages for object 'backupmediafamily'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupmediafamily' (object ID 2069582411).
DBCC results for 'sysjobhistory'.
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:0) with values (job_id =
0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:1) with values (job_id =
0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
2117582582) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:331:138) with values (backup_set_uuid =
C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
to the data row identified by ().
There are 2354 rows in 134 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 4 rows in 1 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
There are 24122 rows in 1050 pages for object 'backupset'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupset' (object ID 2117582582).
DBCC results for 'sysjobservers'.
There are 4 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 17 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 4 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 32 consistency errors in database
'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.You could try instmsdb.sql (Google and you should find info on how to run th
e script). Or perhaps
try to run CHECKDB with the recommended repair option (see the text at the v
ery end of the DBCC
command). Btw, a tip: run CHECKDB using the WITH NO_INFOMSGS option so we on
ly see the errors and
get rid of informational messages...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<andyleffler@.bellsouth.net> wrote in message
news:1147793712.390091.193320@.i39g2000cwa.googlegroups.com...
>I am getting these errors in my event log pertaining to the MSDB
> database. I don't have any backups so I can't restore. Can't I just
> recreate the system databases? What implications will that cause?
> Here's the dbcc checkdb output from QA.
> Any insight would be helpful.
> Andy
> DBCC results for 'msdb'.
> DBCC results for 'sysobjects'.
> There are 394 rows in 8 pages for object 'sysobjects'.
> DBCC results for 'sysindexes'.
> There are 241 rows in 11 pages for object 'sysindexes'.
> DBCC results for 'syscolumns'.
> There are 3468 rows in 123 pages for object 'syscolumns'.
> DBCC results for 'systypes'.
> There are 26 rows in 1 pages for object 'systypes'.
> DBCC results for 'syscomments'.
> There are 402 rows in 163 pages for object 'syscomments'.
> DBCC results for 'sysfiles1'.
> There are 2 rows in 1 pages for object 'sysfiles1'.
> DBCC results for 'syspermissions'.
> There are 185 rows in 1 pages for object 'syspermissions'.
> DBCC results for 'sysusers'.
> There are 17 rows in 1 pages for object 'sysusers'.
> DBCC results for 'sysproperties'.
> There are 0 rows in 0 pages for object 'sysproperties'.
> DBCC results for 'sysdepends'.
> There are 2567 rows in 17 pages for object 'sysdepends'.
> DBCC results for 'sysreferences'.
> There are 12 rows in 1 pages for object 'sysreferences'.
> DBCC results for 'sysfulltextcatalogs'.
> There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
> DBCC results for 'sysfulltextnotify'.
> There are 0 rows in 0 pages for object 'sysfulltextnotify'.
> DBCC results for 'sysfilegroups'.
> There are 1 rows in 1 pages for object 'sysfilegroups'.
> DBCC results for 'sysjobschedules'.
> There are 4 rows in 1 pages for object 'sysjobschedules'.
> DBCC results for 'RTblIfaceMem'.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
> reference from previous page (1:3505). Possible chain linkage problem.
> There are 1189 rows in 6 pages for object 'RTblIfaceMem'.
> DBCC results for 'backupfile'.
> There are 28046 rows in 460 pages for object 'backupfile'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupfile' (object ID 18099105).
> DBCC results for 'syscategories'.
> There are 19 rows in 1 pages for object 'syscategories'.
> DBCC results for 'systargetservers'.
> There are 0 rows in 0 pages for object 'systargetservers'.
> DBCC results for 'RTblWorkspaceItems'.
> There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
> DBCC results for 'restorehistory'.
> There are 54 rows in 1 pages for object 'restorehistory'.
> DBCC results for 'systargetservergroups'.
> There are 0 rows in 0 pages for object 'systargetservergroups'.
> DBCC results for 'RTblDatabaseVersion'.
> There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
> DBCC results for 'systargetservergroupmembers'.
> There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
> DBCC results for 'sysalerts'.
> There are 9 rows in 1 pages for object 'sysalerts'.
> DBCC results for 'RTblDTSProps'.
> There are 0 rows in 0 pages for object 'RTblDTSProps'.
> DBCC results for 'RTblVersionAdminInfo'.
> There are 2333 rows in 22 pages for object 'RTblVersionAdminInfo'.
> DBCC results for 'restorefile'.
> There are 96 rows in 1 pages for object 'restorefile'.
> DBCC results for 'sysoperators'.
> There are 0 rows in 0 pages for object 'sysoperators'.
> DBCC results for 'sysnotifications'.
> There are 0 rows in 0 pages for object 'sysnotifications'.
> DBCC results for 'RTblParameterDef'.
> There are 136 rows in 2 pages for object 'RTblParameterDef'.
> DBCC results for 'restorefilegroup'.
> There are 42 rows in 1 pages for object 'restorefilegroup'.
> DBCC results for 'systaskids'.
> There are 0 rows in 0 pages for object 'systaskids'.
> DBCC results for 'syscachedcredentials'.
> There are 1 rows in 1 pages for object 'syscachedcredentials'.
> DBCC results for 'RTblIfaceHier'.
> There are 3349 rows in 12 pages for object 'RTblIfaceHier'.
> DBCC results for 'logmarkhistory'.
> There are 0 rows in 0 pages for object 'logmarkhistory'.
> DBCC results for 'RTblNamedObj'.
> There are 2196 rows in 15 pages for object 'RTblNamedObj'.
> DBCC results for 'sysdtscategories'.
> There are 3 rows in 1 pages for object 'sysdtscategories'.
> DBCC results for 'sysdtspackages'.
> There are 0 rows in 0 pages for object 'sysdtspackages'.
> DBCC results for 'RTblTypeInfo'.
> There are 0 rows in 0 pages for object 'RTblTypeInfo'.
> DBCC results for 'sysdtspackagelog'.
> There are 0 rows in 0 pages for object 'sysdtspackagelog'.
> DBCC results for 'RTblScriptDefs'.
> There are 0 rows in 0 pages for object 'RTblScriptDefs'.
> DBCC results for 'RTblOLPProps'.
> There are 0 rows in 0 pages for object 'RTblOLPProps'.
> DBCC results for 'sysdtssteplog'.
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
> (sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68528).
> There are 0 rows in 0 pages for object 'sysdtssteplog'.
> DBCC results for 'RTblEnumerationDef'.
> There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
> DBCC results for 'sysdtstasklog'.
> There are 0 rows in 0 pages for object 'sysdtstasklog'.
> DBCC results for 'RTblSumInfo'.
> There are 0 rows in 0 pages for object 'RTblSumInfo'.
> DBCC results for 'RTblMDSProps'.
> There are 0 rows in 0 pages for object 'RTblMDSProps'.
> DBCC results for 'RTblEnumerationValueDef'.
> There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
> DBCC results for 'RTblUMLProps'.
> There are 0 rows in 0 pages for object 'RTblUMLProps'.
> DBCC results for 'sysdbmaintplans'.
> There are 2 rows in 1 pages for object 'sysdbmaintplans'.
> DBCC results for 'sysdbmaintplan_jobs'.
> There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
> DBCC results for 'RTblUMXProps'.
> There are 0 rows in 0 pages for object 'RTblUMXProps'.
> DBCC results for 'sysdbmaintplan_databases'.
> There are 1 rows in 1 pages for object 'sysdbmaintplan_databases'.
> DBCC results for 'RTblSIMProps'.
> There are 0 rows in 0 pages for object 'RTblSIMProps'.
> DBCC results for 'sysdbmaintplan_history'.
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
> (sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68529).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
> (sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68530).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
> (sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68531).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
> (sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68532).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
> (sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68533).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
> (sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68534).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
> (sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68535).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
> (sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68536).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
> (sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68537).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
> (sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68538).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
> (sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68539).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
> (sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68540).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
> (sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68541).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
> (sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68542).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
> (sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68543).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
> (sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68544).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
> (sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68545).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
> (sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68546).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
> (sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68547).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
> (sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68548).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
> (sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68549).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
> (sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68550).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
> (sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68551).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
> (sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68552).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
> (sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68553).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id =
> 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
> (sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68554).
> There are 1000 rows in 41 pages for object 'sysdbmaintplan_history'.
> CHECKDB found 0 allocation errors and 27 consistency errors in table
> 'sysdbmaintplan_history' (object ID 1090102924).
> DBCC results for 'RTblGENProps'.
> There are 0 rows in 0 pages for object 'RTblGENProps'.
> DBCC results for 'RTblDTMProps'.
> There are 0 rows in 0 pages for object 'RTblDTMProps'.
> DBCC results for 'log_shipping_primaries'.
> There are 0 rows in 0 pages for object 'log_shipping_primaries'.
> DBCC results for 'log_shipping_secondaries'.
> There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
> DBCC results for 'RTblDBMProps'.
> There are 0 rows in 0 pages for object 'RTblDBMProps'.
> DBCC results for 'RTblEQMProps'.
> There are 0 rows in 0 pages for object 'RTblEQMProps'.
> DBCC results for 'mswebtasks'.
> There are 0 rows in 0 pages for object 'mswebtasks'.
> DBCC results for 'RTblVersions'.
> There are 2333 rows in 20 pages for object 'RTblVersions'.
> DBCC results for 'RTblDBXProps'.
> There are 0 rows in 0 pages for object 'RTblDBXProps'.
> DBCC results for 'RTblRelships'.
> There are 6922 rows in 97 pages for object 'RTblRelships'.
> DBCC results for 'RTblSites'.
> There are 44 rows in 1 pages for object 'RTblSites'.
> DBCC results for 'RTblProps'.
> There are 393 rows in 2 pages for object 'RTblProps'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index
> 'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:1542:26) with values (media_family_id =
> 124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
> family_sequence_number = 1.499725856E-305) points to the data row
> identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
> (index ID 2). Extra or invalid key for the keys:
> DBCC results for 'RTblRelshipProps'.
> There are 28 rows in 1 pages for object 'RTblRelshipProps'.
> DBCC results for 'RTblPropDefs'.
> There are 797 rows in 7 pages for object 'RTblPropDefs'.
> DBCC results for 'RTblClassExtension'.
> There are 69 rows in 1 pages for object 'RTblClassExtension'.
> DBCC results for 'RTblRelColDefs'.
> There are 320 rows in 2 pages for object 'RTblRelColDefs'.
> DBCC results for 'RTblIfaceDefs'.
> There are 453 rows in 4 pages for object 'RTblIfaceDefs'.
> DBCC results for 'backupmediaset'.
> There are 24118 rows in 249 pages for object 'backupmediaset'.
> DBCC results for 'sqlagent_info'.
> There are 0 rows in 0 pages for object 'sqlagent_info'.
> DBCC results for 'RTblClassDefs'.
> There are 537 rows in 5 pages for object 'RTblClassDefs'.
> DBCC results for 'sysdownloadlist'.
> There are 0 rows in 0 pages for object 'sysdownloadlist'.
> DBCC results for 'backupmediafamily'.
> There are 24118 rows in 459 pages for object 'backupmediafamily'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupmediafamily' (object ID 2069582411).
> DBCC results for 'sysjobhistory'.
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:484:0) with values (job_id =
> 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
> (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:484:1) with values (job_id =
> 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
> 2117582582) (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:331:138) with values (backup_set_uuid =
> C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
> to the data row identified by ().
> There are 2354 rows in 134 pages for object 'sysjobhistory'.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'sysjobhistory' (object ID 2073058421).
> DBCC results for 'sysjobs'.
> There are 4 rows in 1 pages for object 'sysjobs'.
> DBCC results for 'RTblTFMProps'.
> There are 0 rows in 0 pages for object 'RTblTFMProps'.
> DBCC results for 'RTblRelshipDefs'.
> There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
> DBCC results for 'backupset'.
> There are 24122 rows in 1050 pages for object 'backupset'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupset' (object ID 2117582582).
> DBCC results for 'sysjobservers'.
> There are 4 rows in 1 pages for object 'sysjobservers'.
> DBCC results for 'RTblTypeLibs'.
> There are 17 rows in 1 pages for object 'RTblTypeLibs'.
> DBCC results for 'sysjobsteps'.
> There are 4 rows in 1 pages for object 'sysjobsteps'.
> CHECKDB found 0 allocation errors and 32 consistency errors in database
> 'msdb'.
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKDB (msdb ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>|||Tibor,
What will I have to do after I run the instmsdb.sql script? Will I lose
anything important? I don't have any important jobs. I can recreate
those.
here's the output WITH NO_INFOMSGS
Thanks for your help.
Andy
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
reference from previous page (1:3505). Possible chain linkage problem.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
(sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68528).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
(sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68529).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
(sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68530).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
(sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68531).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupfile' (object ID 18099105).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
(sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68532).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
(sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68533).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
(sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68534).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
(sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68535).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
(sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68536).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
(sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68537).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
(sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68538).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
(sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68539).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
(sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68540).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
(sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68541).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
(sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68542).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
(sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68543).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
(sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68544).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
(sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68545).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
(sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68546).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
(sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68547).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
(sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68548).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
(sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68549).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
(sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68550).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
(sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68551).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
(sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68552).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
(sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68553).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id =
774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
(sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68554).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index
'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1542:26) with values (media_family_id =
124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
family_sequence_number = 1.499725856E-305) points to the data row
identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:0) with values (job_id =
0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
the data row identified by ().
CHECKDB found 0 allocation errors and 27 consistency errors in table
'sysdbmaintplan_history' (object ID 1090102924).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupmediafamily' (object ID 2069582411).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:1) with values (job_id =
0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
2117582582) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:331:138) with values (backup_set_uuid =
C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
to the data row identified by ().
CHECKDB found 0 allocation errors and 2 consistency errors in table
'sysjobhistory' (object ID 2073058421).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupset' (object ID 2117582582).
CHECKDB found 0 allocation errors and 32 consistency errors in database
'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (msdb ).|||I got it. I put the database into single user mode then ran DBCC
CHECKDB (databasename', Repair_Rebuild) several times until all the
errors disappeared.
Thanks for your help.
Andy

Error: 644, Severity: 21, State: 3

I am getting these errors in my event log pertaining to the MSDB
database. I don't have any backups so I can't restore. Can't I just
recreate the system databases? What implications will that cause?
Here's the dbcc checkdb output from QA.
Any insight would be helpful.
Andy
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 394 rows in 8 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 241 rows in 11 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3468 rows in 123 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 402 rows in 163 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 185 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 17 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2567 rows in 17 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 4 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
reference from previous page (1:3505). Possible chain linkage problem.
There are 1189 rows in 6 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 28046 rows in 460 pages for object 'backupfile'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupfile' (object ID 18099105).
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 54 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2333 rows in 22 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 96 rows in 1 pages for object 'restorefile'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'RTblParameterDef'.
There are 136 rows in 2 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 42 rows in 1 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3349 rows in 12 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2196 rows in 15 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
(sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68528).
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'sysdbmaintplans'.
There are 2 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 1 rows in 1 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
(sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68529).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
(sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68530).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
(sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68531).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
(sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68532).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
(sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68533).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
(sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68534).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
(sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68535).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
(sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68536).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
(sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68537).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
(sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68538).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
(sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68539).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
(sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68540).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
(sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68541).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
(sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68542).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
(sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68543).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
(sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68544).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
(sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68545).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
(sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68546).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
(sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68547).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
(sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68548).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
(sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68549).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
(sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68550).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
(sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68551).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
(sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68552).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
(sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68553).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
(sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68554).
There are 1000 rows in 41 pages for object 'sysdbmaintplan_history'.
CHECKDB found 0 allocation errors and 27 consistency errors in table
'sysdbmaintplan_history' (object ID 1090102924).
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'RTblVersions'.
There are 2333 rows in 20 pages for object 'RTblVersions'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6922 rows in 97 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 44 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 393 rows in 2 pages for object 'RTblProps'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index
'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1542:26) with values (media_family_id = 124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
family_sequence_number = 1.499725856E-305) points to the data row
identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
There are 797 rows in 7 pages for object 'RTblPropDefs'.
DBCC results for 'RTblClassExtension'.
There are 69 rows in 1 pages for object 'RTblClassExtension'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 2 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 453 rows in 4 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 24118 rows in 249 pages for object 'backupmediaset'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
There are 24118 rows in 459 pages for object 'backupmediafamily'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupmediafamily' (object ID 2069582411).
DBCC results for 'sysjobhistory'.
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:0) with values (job_id = 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:1) with values (job_id = 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
2117582582) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:331:138) with values (backup_set_uuid = C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
to the data row identified by ().
There are 2354 rows in 134 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 4 rows in 1 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
There are 24122 rows in 1050 pages for object 'backupset'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupset' (object ID 2117582582).
DBCC results for 'sysjobservers'.
There are 4 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 17 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 4 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 32 consistency errors in database
'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.You could try instmsdb.sql (Google and you should find info on how to run the script). Or perhaps
try to run CHECKDB with the recommended repair option (see the text at the very end of the DBCC
command). Btw, a tip: run CHECKDB using the WITH NO_INFOMSGS option so we only see the errors and
get rid of informational messages...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<andyleffler@.bellsouth.net> wrote in message
news:1147793712.390091.193320@.i39g2000cwa.googlegroups.com...
>I am getting these errors in my event log pertaining to the MSDB
> database. I don't have any backups so I can't restore. Can't I just
> recreate the system databases? What implications will that cause?
> Here's the dbcc checkdb output from QA.
> Any insight would be helpful.
> Andy
> DBCC results for 'msdb'.
> DBCC results for 'sysobjects'.
> There are 394 rows in 8 pages for object 'sysobjects'.
> DBCC results for 'sysindexes'.
> There are 241 rows in 11 pages for object 'sysindexes'.
> DBCC results for 'syscolumns'.
> There are 3468 rows in 123 pages for object 'syscolumns'.
> DBCC results for 'systypes'.
> There are 26 rows in 1 pages for object 'systypes'.
> DBCC results for 'syscomments'.
> There are 402 rows in 163 pages for object 'syscomments'.
> DBCC results for 'sysfiles1'.
> There are 2 rows in 1 pages for object 'sysfiles1'.
> DBCC results for 'syspermissions'.
> There are 185 rows in 1 pages for object 'syspermissions'.
> DBCC results for 'sysusers'.
> There are 17 rows in 1 pages for object 'sysusers'.
> DBCC results for 'sysproperties'.
> There are 0 rows in 0 pages for object 'sysproperties'.
> DBCC results for 'sysdepends'.
> There are 2567 rows in 17 pages for object 'sysdepends'.
> DBCC results for 'sysreferences'.
> There are 12 rows in 1 pages for object 'sysreferences'.
> DBCC results for 'sysfulltextcatalogs'.
> There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
> DBCC results for 'sysfulltextnotify'.
> There are 0 rows in 0 pages for object 'sysfulltextnotify'.
> DBCC results for 'sysfilegroups'.
> There are 1 rows in 1 pages for object 'sysfilegroups'.
> DBCC results for 'sysjobschedules'.
> There are 4 rows in 1 pages for object 'sysjobschedules'.
> DBCC results for 'RTblIfaceMem'.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
> reference from previous page (1:3505). Possible chain linkage problem.
> There are 1189 rows in 6 pages for object 'RTblIfaceMem'.
> DBCC results for 'backupfile'.
> There are 28046 rows in 460 pages for object 'backupfile'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupfile' (object ID 18099105).
> DBCC results for 'syscategories'.
> There are 19 rows in 1 pages for object 'syscategories'.
> DBCC results for 'systargetservers'.
> There are 0 rows in 0 pages for object 'systargetservers'.
> DBCC results for 'RTblWorkspaceItems'.
> There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
> DBCC results for 'restorehistory'.
> There are 54 rows in 1 pages for object 'restorehistory'.
> DBCC results for 'systargetservergroups'.
> There are 0 rows in 0 pages for object 'systargetservergroups'.
> DBCC results for 'RTblDatabaseVersion'.
> There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
> DBCC results for 'systargetservergroupmembers'.
> There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
> DBCC results for 'sysalerts'.
> There are 9 rows in 1 pages for object 'sysalerts'.
> DBCC results for 'RTblDTSProps'.
> There are 0 rows in 0 pages for object 'RTblDTSProps'.
> DBCC results for 'RTblVersionAdminInfo'.
> There are 2333 rows in 22 pages for object 'RTblVersionAdminInfo'.
> DBCC results for 'restorefile'.
> There are 96 rows in 1 pages for object 'restorefile'.
> DBCC results for 'sysoperators'.
> There are 0 rows in 0 pages for object 'sysoperators'.
> DBCC results for 'sysnotifications'.
> There are 0 rows in 0 pages for object 'sysnotifications'.
> DBCC results for 'RTblParameterDef'.
> There are 136 rows in 2 pages for object 'RTblParameterDef'.
> DBCC results for 'restorefilegroup'.
> There are 42 rows in 1 pages for object 'restorefilegroup'.
> DBCC results for 'systaskids'.
> There are 0 rows in 0 pages for object 'systaskids'.
> DBCC results for 'syscachedcredentials'.
> There are 1 rows in 1 pages for object 'syscachedcredentials'.
> DBCC results for 'RTblIfaceHier'.
> There are 3349 rows in 12 pages for object 'RTblIfaceHier'.
> DBCC results for 'logmarkhistory'.
> There are 0 rows in 0 pages for object 'logmarkhistory'.
> DBCC results for 'RTblNamedObj'.
> There are 2196 rows in 15 pages for object 'RTblNamedObj'.
> DBCC results for 'sysdtscategories'.
> There are 3 rows in 1 pages for object 'sysdtscategories'.
> DBCC results for 'sysdtspackages'.
> There are 0 rows in 0 pages for object 'sysdtspackages'.
> DBCC results for 'RTblTypeInfo'.
> There are 0 rows in 0 pages for object 'RTblTypeInfo'.
> DBCC results for 'sysdtspackagelog'.
> There are 0 rows in 0 pages for object 'sysdtspackagelog'.
> DBCC results for 'RTblScriptDefs'.
> There are 0 rows in 0 pages for object 'RTblScriptDefs'.
> DBCC results for 'RTblOLPProps'.
> There are 0 rows in 0 pages for object 'RTblOLPProps'.
> DBCC results for 'sysdtssteplog'.
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
> (sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68528).
> There are 0 rows in 0 pages for object 'sysdtssteplog'.
> DBCC results for 'RTblEnumerationDef'.
> There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
> DBCC results for 'sysdtstasklog'.
> There are 0 rows in 0 pages for object 'sysdtstasklog'.
> DBCC results for 'RTblSumInfo'.
> There are 0 rows in 0 pages for object 'RTblSumInfo'.
> DBCC results for 'RTblMDSProps'.
> There are 0 rows in 0 pages for object 'RTblMDSProps'.
> DBCC results for 'RTblEnumerationValueDef'.
> There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
> DBCC results for 'RTblUMLProps'.
> There are 0 rows in 0 pages for object 'RTblUMLProps'.
> DBCC results for 'sysdbmaintplans'.
> There are 2 rows in 1 pages for object 'sysdbmaintplans'.
> DBCC results for 'sysdbmaintplan_jobs'.
> There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
> DBCC results for 'RTblUMXProps'.
> There are 0 rows in 0 pages for object 'RTblUMXProps'.
> DBCC results for 'sysdbmaintplan_databases'.
> There are 1 rows in 1 pages for object 'sysdbmaintplan_databases'.
> DBCC results for 'RTblSIMProps'.
> There are 0 rows in 0 pages for object 'RTblSIMProps'.
> DBCC results for 'sysdbmaintplan_history'.
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
> (sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68529).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
> (sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68530).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
> (sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68531).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
> (sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68532).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
> (sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68533).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
> (sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68534).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
> (sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68535).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
> (sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68536).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
> (sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68537).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
> (sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68538).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
> (sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68539).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
> (sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68540).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
> (sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68541).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
> (sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68542).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
> (sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68543).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
> (sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68544).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
> (sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68545).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
> (sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68546).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
> (sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68547).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
> (sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68548).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
> (sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68549).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
> (sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68550).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
> (sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68551).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
> (sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68552).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
> (sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68553).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
> invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
> row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id => 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
> (sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
> and ? = 68554).
> There are 1000 rows in 41 pages for object 'sysdbmaintplan_history'.
> CHECKDB found 0 allocation errors and 27 consistency errors in table
> 'sysdbmaintplan_history' (object ID 1090102924).
> DBCC results for 'RTblGENProps'.
> There are 0 rows in 0 pages for object 'RTblGENProps'.
> DBCC results for 'RTblDTMProps'.
> There are 0 rows in 0 pages for object 'RTblDTMProps'.
> DBCC results for 'log_shipping_primaries'.
> There are 0 rows in 0 pages for object 'log_shipping_primaries'.
> DBCC results for 'log_shipping_secondaries'.
> There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
> DBCC results for 'RTblDBMProps'.
> There are 0 rows in 0 pages for object 'RTblDBMProps'.
> DBCC results for 'RTblEQMProps'.
> There are 0 rows in 0 pages for object 'RTblEQMProps'.
> DBCC results for 'mswebtasks'.
> There are 0 rows in 0 pages for object 'mswebtasks'.
> DBCC results for 'RTblVersions'.
> There are 2333 rows in 20 pages for object 'RTblVersions'.
> DBCC results for 'RTblDBXProps'.
> There are 0 rows in 0 pages for object 'RTblDBXProps'.
> DBCC results for 'RTblRelships'.
> There are 6922 rows in 97 pages for object 'RTblRelships'.
> DBCC results for 'RTblSites'.
> There are 44 rows in 1 pages for object 'RTblSites'.
> DBCC results for 'RTblProps'.
> There are 393 rows in 2 pages for object 'RTblProps'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index
> 'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:1542:26) with values (media_family_id => 124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
> family_sequence_number = 1.499725856E-305) points to the data row
> identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
> (index ID 2). Extra or invalid key for the keys:
> DBCC results for 'RTblRelshipProps'.
> There are 28 rows in 1 pages for object 'RTblRelshipProps'.
> DBCC results for 'RTblPropDefs'.
> There are 797 rows in 7 pages for object 'RTblPropDefs'.
> DBCC results for 'RTblClassExtension'.
> There are 69 rows in 1 pages for object 'RTblClassExtension'.
> DBCC results for 'RTblRelColDefs'.
> There are 320 rows in 2 pages for object 'RTblRelColDefs'.
> DBCC results for 'RTblIfaceDefs'.
> There are 453 rows in 4 pages for object 'RTblIfaceDefs'.
> DBCC results for 'backupmediaset'.
> There are 24118 rows in 249 pages for object 'backupmediaset'.
> DBCC results for 'sqlagent_info'.
> There are 0 rows in 0 pages for object 'sqlagent_info'.
> DBCC results for 'RTblClassDefs'.
> There are 537 rows in 5 pages for object 'RTblClassDefs'.
> DBCC results for 'sysdownloadlist'.
> There are 0 rows in 0 pages for object 'sysdownloadlist'.
> DBCC results for 'backupmediafamily'.
> There are 24118 rows in 459 pages for object 'backupmediafamily'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupmediafamily' (object ID 2069582411).
> DBCC results for 'sysjobhistory'.
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:484:0) with values (job_id => 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
> (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:484:1) with values (job_id => 0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
> 2117582582) (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:331:138) with values (backup_set_uuid => C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
> to the data row identified by ().
> There are 2354 rows in 134 pages for object 'sysjobhistory'.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'sysjobhistory' (object ID 2073058421).
> DBCC results for 'sysjobs'.
> There are 4 rows in 1 pages for object 'sysjobs'.
> DBCC results for 'RTblTFMProps'.
> There are 0 rows in 0 pages for object 'RTblTFMProps'.
> DBCC results for 'RTblRelshipDefs'.
> There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
> DBCC results for 'backupset'.
> There are 24122 rows in 1050 pages for object 'backupset'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'backupset' (object ID 2117582582).
> DBCC results for 'sysjobservers'.
> There are 4 rows in 1 pages for object 'sysjobservers'.
> DBCC results for 'RTblTypeLibs'.
> There are 17 rows in 1 pages for object 'RTblTypeLibs'.
> DBCC results for 'sysjobsteps'.
> There are 4 rows in 1 pages for object 'sysjobsteps'.
> CHECKDB found 0 allocation errors and 32 consistency errors in database
> 'msdb'.
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKDB (msdb ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>|||Tibor,
What will I have to do after I run the instmsdb.sql script? Will I lose
anything important? I don't have any important jobs. I can recreate
those.
here's the output WITH NO_INFOMSGS
Thanks for your help.
Andy
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 18099105, index ID 1. Page (1:3506) is missing a
reference from previous page (1:3505). Possible chain linkage problem.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:0) identified by (RID = (1:1330:0) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68528) has index values
(sequence_id = 73506 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68528).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:1) identified by (RID = (1:1330:1) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68529) has index values
(sequence_id = 73507 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68529).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:2) identified by (RID = (1:1330:2) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68530) has index values
(sequence_id = 73508 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68530).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:3) identified by (RID = (1:1330:3) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68531) has index values
(sequence_id = 73509 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68531).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupfile' (object ID 18099105).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:4) identified by (RID = (1:1330:4) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68532) has index values
(sequence_id = 73510 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68532).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:5) identified by (RID = (1:1330:5) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68533) has index values
(sequence_id = 73511 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68533).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:6) identified by (RID = (1:1330:6) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68534) has index values
(sequence_id = 73512 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68534).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:7) identified by (RID = (1:1330:7) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68535) has index values
(sequence_id = 73513 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68535).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:8) identified by (RID = (1:1330:8) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68536) has index values
(sequence_id = 73514 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68536).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:9) identified by (RID = (1:1330:9) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68537) has index values
(sequence_id = 73515 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68537).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:10) identified by (RID = (1:1330:10) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68538) has index values
(sequence_id = 73516 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68538).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:11) identified by (RID = (1:1330:11) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68539) has index values
(sequence_id = 73517 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68539).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:12) identified by (RID = (1:1330:12) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68540) has index values
(sequence_id = 73518 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68540).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:13) identified by (RID = (1:1330:13) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68541) has index values
(sequence_id = 73519 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68541).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:14) identified by (RID = (1:1330:14) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68542) has index values
(sequence_id = 73520 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68542).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:15) identified by (RID = (1:1330:15) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68543) has index values
(sequence_id = 73521 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68543).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:16) identified by (RID = (1:1330:16) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68544) has index values
(sequence_id = 73522 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68544).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:17) identified by (RID = (1:1330:17) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68545) has index values
(sequence_id = 73523 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68545).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:18) identified by (RID = (1:1330:18) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68546) has index values
(sequence_id = 73524 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68546).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:19) identified by (RID = (1:1330:19) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68547) has index values
(sequence_id = 73525 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68547).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:20) identified by (RID = (1:1330:20) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68548) has index values
(sequence_id = 73526 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68548).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:21) identified by (RID = (1:1330:21) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68549) has index values
(sequence_id = 73527 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68549).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:22) identified by (RID = (1:1330:22) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68550) has index values
(sequence_id = 73528 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68550).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:23) identified by (RID = (1:1330:23) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68551) has index values
(sequence_id = 73529 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68551).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:24) identified by (RID = (1:1330:24) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68552) has index values
(sequence_id = 73530 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68552).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:25) identified by (RID = (1:1330:25) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68553) has index values
(sequence_id = 73531 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68553).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysdbmaintplan_history' (ID 1090102924). Missing or
invalid key in index 'UQ__sysdbmaintplan_h__41EDCAC5' (ID 2) for the
row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1330:26) identified by (RID = (1:1330:26) plan_id =774C472B-B47C-4AC5-8EA9-F4FC76B68F8B and ? = 68554) has index values
(sequence_id = 73532 and plan_id = 774C472B-B47C-4AC5-8EA9-F4FC76B68F8B
and ? = 68554).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index
'backupmediafamily.backupmediafamilyuuid' (ID 2069582411) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1542:26) with values (media_family_id =124C64EE-0000-0000-0000-000000000000 and media_set_id = 18046 and
family_sequence_number = 1.499725856E-305) points to the data row
identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:0) with values (job_id =0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5909) points to
the data row identified by ().
CHECKDB found 0 allocation errors and 27 consistency errors in table
'sysdbmaintplan_history' (object ID 1090102924).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupmediafamily' (object ID 2069582411).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'sysjobhistory.nc1' (ID 2073058421)
(index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:484:1) with values (job_id =0C4E74E1-FFCD-4812-B456-6F563B61D3D6 and instance_id = 5910) points to
the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'msdb', index 'backupset.backupsetuuid' (ID
2117582582) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:331:138) with values (backup_set_uuid =C89DADB3-32FA-4F2C-A0FC-88897BDF8DCE and backup_set_id = 18058) points
to the data row identified by ().
CHECKDB found 0 allocation errors and 2 consistency errors in table
'sysjobhistory' (object ID 2073058421).
CHECKDB found 0 allocation errors and 1 consistency errors in table
'backupset' (object ID 2117582582).
CHECKDB found 0 allocation errors and 32 consistency errors in database
'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (msdb ).|||I got it. I put the database into single user mode then ran DBCC
CHECKDB (databasename', Repair_Rebuild) several times until all the
errors disappeared.
Thanks for your help.
Andy