|
sica
Posting Yak Master
143 Posts |
 Posted - 2001-08-31 : 03:10:10
|
| Hi,When I run DBCC CHECKDB (db) I get the following error messages :"Server: Msg 2535, Level 16, State 2, Line 1Table Corrupt: Page (1:1798015) is allocated to object ID 879342197, index ID 4, not to object ID 288, index ID 9 found in page header.Server: Msg 8909, Level 16, State 1, Line 1Table Corrupt: Object ID 288, index ID 9, page ID (1:1798015). The PageId in the page header = (0:9439254).Server: Msg 8944, Level 16, State 1, Line 1Table Corrupt: Object ID 879342197, index ID 0, page (1:1191341), row 0. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 192 and 193.Server: Msg 8941, Level 16, State 1, Line 1Table Corrupt: Object ID 879342197, index ID 0, page (1:1191343). Test (sorted [i].offset <= m_freeData) failed. Slot 0, offset 0x9048 is invalid.Server: Msg 8928, Level 16, State 1, Line 1Object ID 879342197, index ID 4: Page (1:1798013) could not be processed. See other errors for details.Server: Msg 8976, Level 16, State 1, Line 1Table Corrupt: Object ID 879342197, index ID 4. Page (1:1798013) not allocated or corrupt. Parent (1:1663800) and previous (1:1798012) refer to it.Server: Msg 8942, Level 16, State 1, Line 1Table Corrupt: Object ID 879342197, index ID 4, page (1:1798014). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x0 overlaps with the prior row."Does anybody know what this error message stands for?I tried to put the db in the single-user mode to run a repair on the db but every time I tried I keep getting the message that I not the owner of the object.But I'm the owner and I'm the only one present in the db.I run query from ANALYZER on SQL SERVER 7.0Any ideas?Thanks.//Sica |
|
DBCC CHECKDB