logical consistency-based I/O error

Question

Post reply

logical consistency-based I/O error

Viewing 15 posts - 16 through 30 (of 32 total)

You must be logged in to reply to this topic. Login to reply

eh.shams Ten Centuries Points: 1325 More actions · Answer 1

hello , i run command ,and it be okay.

but now when i want to create new Maintenance on saving it give me this error :

TITLE: Maintenance Plan Wizard Progress

------------------------------

Saving maintenance plan failed.

------------------------------

ADDITIONAL INFORMATION:

Class not registered

------------------------------

Class not registered

------------------------------

BUTTONS:

OK

------------------------------

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 2

Gail Shaw

SSC Guru

Points: 1004494

February 4, 2013 at 5:21 am

#1583900

Which command did you run? The repair? If so, what was the output?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 3

eh.shams

Ten Centuries

Points: 1325

February 5, 2013 at 1:28 am

#1584212

1)stop agent

2)ALTER DATABASE WFilter SET Single_User WITH ROLLBACK IMMEDIATE

3)DBCC CHECKDB (WFilter, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

it give no error , sucessfuly run

4)ALTER DATABASE WFilter SET MULTI_USER

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 4

Why did you run that on the database WFilter when it's MSDB that's damaged?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 5

eh.shams

Ten Centuries

Points: 1325

February 5, 2013 at 3:20 am

#1584251

ok, before i run on msdb i run these command on wfilter database for test ,

i do them with msdb

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 6

Why would you run them on an undamaged database to 'test'? Seeing as the command is intended repair damage, running on an undamaged database is not going to test anything.

Want to test, restore a backup of the damaged MSDB database to another server (as a user database) and test there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 7

eh.shams

Ten Centuries

Points: 1325

February 5, 2013 at 5:08 am

#1584310

ok, you're right . now why i cant create maitenance plan ? before message ?

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 8

Have you fixed the errors in MSDB yet? If not, that's probably why you can't create a maint plan.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 9

before running command i get back up, i restore msdb and stop agent , single mode ,after runing :

DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

it give me this :

Repair: The Clustered index successfully rebuilt for the object "dbo.sysjobhistory" in database "msdb".

Repair: The page (1:660) has been deallocated from object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data).

Repair: The Nonclustered index successfully rebuilt for the object "dbo.sysjobhistory, nc1" in database "msdb".

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1 will be rebuilt.

The error has been repaired.

Msg 8979, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Page (1:656) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in system catalog.

The error has been repaired.

Msg 8928, Level 16, State 1, Line 1

Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data): Page (1:660) could not be processed. See other errors for details.

The error has been repaired.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data), page (1:660). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -4.

The error has been repaired.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Index node page (0:0), slot 0 refers to child page (1:660) and previous child (0:0), but they were not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:661) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:700) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:705) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:712) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:736) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:737) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:738) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:739) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:740) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:741) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:742) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:743) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:850) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:937) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:1112) was not encountered.

The error has been repaired.

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 2 will be rebuilt.

The error has been repaired.

CHECKDB found 0 allocation errors and 19 consistency errors in table 'sysjobhistory' (object ID 117575457).

CHECKDB fixed 0 allocation errors and 19 consistency errors in table 'sysjobhistory' (object ID 117575457).

Repair: The Clustered index successfully rebuilt for the object "dbo.sysmaintplan_log" in database "msdb".

Repair: The page (1:620) has been deallocated from object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data).

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 901578250, index ID 1 will be rebuilt.

The error has been repaired.

Msg 8928, Level 16, State 1, Line 1

Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data): Page (1:620) could not be processed. See other errors for details.

The error has been repaired.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data), page (1:620). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130025481 and -4.

The error has been repaired.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data). Index node page (1:849), slot 0 refers to child page (1:620) and previous child (0:0), but they were not encountered.

The error has been repaired.

CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysmaintplan_log' (object ID 901578250).

CHECKDB fixed 0 allocation errors and 3 consistency errors in table 'sysmaintplan_log' (object ID 901578250).

Repair: The Clustered index successfully rebuilt for the object "dbo.backupset" in database "msdb".

Repair: The page (1:698) has been deallocated from object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data).

Repair: The Nonclustered index successfully rebuilt for the object "dbo.backupset, backupsetuuid" in database "msdb".

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1 will be rebuilt.

The error has been repaired.

Msg 8979, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Page (1:630) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in system catalog.

The error has been repaired.

Msg 8928, Level 16, State 1, Line 1

Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data): Page (1:698) could not be processed. See other errors for details.

The error has been repaired.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data), page (1:698). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130025481 and -4.

The error has been repaired.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Index node page (0:0), slot 0 refers to child page (1:698) and previous child (0:0), but they were not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:699) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:703) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:710) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:713) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:729) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:732) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:744) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:745) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:746) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:747) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:748) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:749) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:750) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:751) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:792) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:793) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:794) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:795) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:796) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:797) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:798) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:799) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:840) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:841) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:842) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:843) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:844) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:845) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:846) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:847) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:880) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:881) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:882) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:883) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:884) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:885) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:886) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:887) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:928) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:929) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:930) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:931) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:932) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:933) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:934) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:935) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:960) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:961) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:962) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:963) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:964) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:965) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:966) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:967) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1008) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1009) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1010) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1011) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1012) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1013) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1014) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1015) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1040) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1041) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1042) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1043) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1044) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1045) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1046) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1047) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1064) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1065) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1066) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1067) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1068) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1069) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1070) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1104) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1105) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1106) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1107) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1108) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1109) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1110) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1111) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2016) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2017) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2018) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2019) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2020) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2021) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2022) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2023) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2056) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2057) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2058) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2059) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2060) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2061) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2062) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2063) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2128) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2129) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2130) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2131) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2132) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2133) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2134) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2135) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3160) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3161) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3162) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3163) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3164) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3165) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3166) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3167) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3192) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3193) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3194) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3195) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3196) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3197) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3198) was not encountered.

The error has been repaired.

Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3199) was not encountered.

The error has been repaired.

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 1954106002, index ID 2 will be rebuilt.

The error has been repaired.

CHECKDB found 0 allocation errors and 129 consistency errors in table 'backupset' (object ID 1954106002).

CHECKDB fixed 0 allocation errors and 129 consistency errors in table 'backupset' (object ID 1954106002).

Repair: The Clustered index successfully rebuilt for the object "dbo.backupfile" in database "msdb".

Repair: The page (1:1072) has been deallocated from object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data).

Msg 8945, Level 16, State 1, Line 1

Table error: Object ID 2050106344, index ID 1 will be rebuilt.

The error has been repaired.

Msg 8928, Level 16, State 1, Line 1

Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data): Page (1:1072) could not be processed. See other errors for details.

The error has been repaired.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data), page (1:1072). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130025481 and -4.

The error has been repaired.

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data). Page (1:1072) was not seen in the scan although its parent (1:696) and previous (1:1055) refer to it. Check any previous errors.

The error has been repaired.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data). Page (1:1073) is missing a reference from previous page (1:1072). Possible chain linkage problem.

The error has been repaired.

CHECKDB found 0 allocation errors and 4 consistency errors in table 'backupfile' (object ID 2050106344).

CHECKDB fixed 0 allocation errors and 4 consistency errors in table 'backupfile' (object ID 2050106344).

CHECKDB found 0 allocation errors and 155 consistency errors in database 'msdb'.

CHECKDB fixed 0 allocation errors and 155 consistency errors in database 'msdb'.

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 10

Gail Shaw

SSC Guru

Points: 1004494

February 11, 2013 at 6:08 am

#1586512

Looks like all errors were fixed. Now sort out your backup strategy.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 11

eh.shams

Ten Centuries

Points: 1325

February 11, 2013 at 10:02 pm

#1586831

sql server give me this error : "class not registered "

can i install SQLServer2005_SSMSEE.exe ?to resolveissue ?

eh.shams Ten Centuries Points: 1325 More actions · Answer 12

eh.shams

Ten Centuries

Points: 1325

February 11, 2013 at 10:35 pm

#1586838

dose installing mssql2005 sp3.0 resolve issue ?

Chris Burton-434978 SSC Veteran Points: 253 More actions · Answer 13

We had similar corruption to this in msdb last week with Parent node for page (X:XXX) was not encountered errors

I took a backup which included the corruption and restored under a different name and ran DBCC CHECKDB REPAIR_REBUILD against the restored database which managed to fix it so did the same on the msdb database. The repair seemed to work fine and no errors have been picked up since and we did not experience any data loss by using this method

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 14

Chris Burton-434978 (2/13/2013)

We had similar corruption to this in msdb last week with Parent node for page (X:XXX) was not encountered errors

I took a backup which included the corruption and restored under a different name and ran DBCC CHECKDB REPAIR_REBUILD against the restored database which managed to fix it so did the same on the msdb database. The repair seemed to work fine and no errors have been picked up since and we did not experience any data loss by using this method

Repair rebuild only works if the minimum level to repair as specified by checkDB is repair_rebuild. In your case, it apparently was, in this case it was not and running a repair_rebuild when the minimum level to repair is specified as repair_allow_data_loss is a waste of time.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

eh.shams Ten Centuries Points: 1325 More actions · Answer 15

eh.shams

Ten Centuries

Points: 1325

February 15, 2013 at 11:09 am

#1588440

in you'r opinion what can i do ?which command run ?