|
ETL_DBA
Starting Member
2 Posts |
 Posted - 04/02/2012 : 13:40:32
|
Like some others that have posted here, I've been thrown into the fire to solve a situation picking up where someone else left off ... so here goes ...
Ran DBCC on our main database and this is the output I receive:
[To my untrained eye, it's not huge but still a problem to tend to just the same]
-----------------
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 255, page ID (1:478741). The PageId in the page header = (1:478749).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 255, page ID (1:478742). The PageId in the page header = (1:478750).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 255, page ID (1:478743). The PageId in the page header = (1:478751).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1680594367, index ID 0: Page (1:478740) could not be processed. See other errors for details.
Server: Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 1680594367, index ID 0, page (1:478740). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 7, offset 0x1 is invalid.
Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 1680594367, index ID 0, page (1:478740). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x7 overlaps with the prior row.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1680594367, index ID 0: Page (1:478741) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1680594367, index ID 0: Page (1:478742) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1680594367, index ID 0: Page (1:478743) could not be processed. See other errors for details.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 6 consistency errors in table 'tmp_anal_grp_mthds_bak' (object ID 1680594367).
CHECKDB found 0 allocation errors and 9 consistency errors in database 'Newburgh'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Newburgh ).
----------------------------
Just looking for a little direction. Since I'm seeing the name of a tmp table I'm leaning towards a repair but I need to do "due diligence" and see if I can see what the data actually is.
Thanks.
Kevin |
|
A little direction ...
