SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBCC CHECKDB Error?


DBCC CHECKDB Error?

Author
Message
crazy4sql
crazy4sql
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1675 Visits: 4489

DBCC results for 'BC_ShiftSummaryInfo'.
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856104448 owned by data record identified by RID = (1:541810:40)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856759808 owned by data record identified by RID = (1:541810:50)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29854859264 owned by data record identified by RID = (1:541811:31)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 30184964096 owned by data record identified by RID = (1:551711:43)
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:542654) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 0, text ID 29854859264 is referenced by page (1:531974), slot 4, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 1, text ID 29856759808 is referenced by page (1:531982), slot 2, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 2, text ID 30184964096 is referenced by page (1:551711), slot 43, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:542686) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542686), slot 0, text ID 29856104448 is referenced by page (1:531822), slot 9, but was not seen in the scan.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:553670), slot 18, text ID 30184964096 is not referenced.
There are 310724 rows in 2785 pages for object "BC_ShiftSummaryInfo".
CHECKDB found 0 allocation errors and 11 consistency errors in table 'BC_ShiftSummaryInfo' (object ID 990626572).



How critical is this table "BC_ShiftSummaryInfo" for you? Can you bring the data back in this table from some old working backup (by restoring that backup as new database and then copy the data from table) and the re-run dbcc checkdb?

----------
Ashish
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