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

elliswhite
Starting Member

36 Posts

Posted - 05/10/2014 :  04:13:29  Show Profile  Reply with Quote
You need to restore SQL database from ful backup if the full backup is not available then try any entrusted SQL recovery tool.
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.05 seconds. Powered By: Snitz Forums 2000