SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 A little direction ...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ETL_DBA
Starting Member

2 Posts

Posted - 04/02/2012 :  13:40:32  Show Profile  Reply with Quote
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

ETL_DBA
Starting Member

2 Posts

Posted - 04/02/2012 :  14:05:03  Show Profile  Reply with Quote
This is SQL 2000, by the way ....
Go to Top of Page

prett
Posting Yak Master

USA
181 Posts

Posted - 04/12/2012 :  02:12:44  Show Profile  Visit prett's Homepage  Reply with Quote
I found this Microsoft Kb article article on this error:

http://support.microsoft.com/kb/308795

One more article: http://recoverdatabase.blogspot.in/2011/09/how-to-resolve-error-msg-823-level-24.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000