February 4, 2013 at 4:24 am
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
------------------------------
February 4, 2013 at 5:21 am
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
February 5, 2013 at 1:28 am
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
February 5, 2013 at 2:42 am
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
February 5, 2013 at 3:20 am
ok, before i run on msdb i run these command on wfilter database for test ,
i do them with msdb
February 5, 2013 at 3:53 am
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
February 5, 2013 at 5:08 am
ok, you're right . now why i cant create maitenance plan ? before message ?
February 5, 2013 at 5:46 am
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
February 11, 2013 at 3:08 am
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'.
February 11, 2013 at 6:08 am
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
February 11, 2013 at 10:02 pm
sql server give me this error : "class not registered "
can i install SQLServer2005_SSMSEE.exe ?to resolveissue ?
February 11, 2013 at 10:35 pm
dose installing mssql2005 sp3.0 resolve issue ?
February 13, 2013 at 7:41 am
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
February 13, 2013 at 9:22 am
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 errorsI 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
February 15, 2013 at 11:09 am
in you'r opinion what can i do ?which command run ?
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply