Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLServer Error: 824


SQLServer Error: 824

Author
Message
eh.shams
eh.shams
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 136
Hello , i defined a job (full back up) in sql server 2005 before , 3 monthe ago , it work's correctly before , today give this error when i running job , I install sp3.0 on my MSSQL.

Message
[298] SQLServer Error: 824, SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6056dae7; actual: 0x60acdbe2). It occurred during a read of page (1:660) in database ID 4 at offset 0x00000000528000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE HY000] (ConnExecuteCachableOp)


How can i correct it ? would you please help me ?
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47273 Visits: 44392
Please run the following and post the full and complete output.


DBCC CHECKDB (<Database Name>Wink WITH NO_INFOMSGS, ALL_ERRORMSGS



Depending how bad this is, it may be necessary to restore from backups. Do you have clean (uncorrupted) backups of this database. For some background info on what's happened take a look at this article. http://www.sqlservercentral.com/articles/65804/


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
eh.shams
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 136
i run :
DBCC CHECKDB (MSDBData) WITH NO_INFOMSGS, ALL_ERRORMSGS

give me the error : the data base doesnt exist ?!?
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47273 Visits: 44392
MSDBData is the name of the file, not the name of the database. If you query sys.databases, you'll see that database 4 (ID given in the error message) is called MSDB.


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


GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47273 Visits: 44392
Just to check, you do have backups of MSDB? You have been backing up the system databases?


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
eh.shams
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 136
yes, i have back up from my data bases
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47273 Visits: 44392
Good. So what's the output from CheckDB?


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
eh.shams
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 136
i run that command , give me this message what should i do ?
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.
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.
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 130156553 and -4.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
CHECKDB found 0 allocation errors and 19 consistency errors in table 'sysjobhistory' (object ID 117575457).
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.
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 130156553 and -4.
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.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysmaintplan_log' (object ID 901578250).
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.
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.
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 130156553 and -4.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
CHECKDB found 0 allocation errors and 129 consistency errors in table 'backupset' (object ID 1954106002).
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.
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 130156553 and -4.
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.
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.
CHECKDB found 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'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (msdb).
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47273 Visits: 44392
I strongly suggest that you restore MSDB from backup. You've got some nasty corruption there and repairing the system databases is not generally recommended.

Restoring MSDB isn't the same as for the user databases, check Books Online (or the MSDN website) for details on how to do that.

Edit: You should also do some investigation of the IO subsystem. Looks like some pages have been zeroed out, that's typically an IO subsystem problem.


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
eh.shams
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 136
sorry , i check my back up folder i dont have back up MSDB back up , there is my data base back up and adventure work back up , what should i do now ?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search