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
 Checkdb results
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jdbrown239
Starting Member

USA
1 Posts

Posted - 09/11/2012 :  16:43:01  Show Profile  Reply with Quote
Can any one give me an idea of the severity of these message and what they mean?

The Index Allocation Map (IAM) page (3:443009) is pointed to by the next pointer of IAM page (3:46916) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057617638096896 (type Unknown), but it was not detected in the scan.
Msg 2576, Level 16, State 1, Line 1
The Index Allocation Map (IAM) page (3:443009) is pointed to by the previous pointer of IAM page (3:56127) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057617638096896 (type Unknown), but it was not detected in the scan.
CHECKDB found 8 allocation errors and 0 consistency errors not associated with any single object.

Msg 8910, Level 16, State 1, Line 1
Page (3:441883) in database ID 5 is allocated to both object ID 46935539, index ID 1, partition ID 72057615824584704, alloc unit ID 72057617649303552 (type In-row data), and object ID 1548844880, index ID 1, partition ID 72057615819341824, alloc unit ID 72057617643536384 (type In-row data).

chadmat
The Chadinator

USA
1974 Posts

Posted - 09/11/2012 :  16:51:25  Show Profile  Visit chadmat's Homepage  Reply with Quote
Pretty severe. You have data corruption, best thing to do is restore from backup.

-Chad
Go to Top of Page

Trevinator
Starting Member

8 Posts

Posted - 11/29/2012 :  17:59:59  Show Profile  Reply with Quote
You can also dump the table then drop the table then LOAD DATA your file back into a table.
Go to Top of Page

jayismyson
Starting Member

China
4 Posts

Posted - 03/20/2013 :  02:26:13  Show Profile  Reply with Quote
best thing to do is restore from backup.


_________________
http://www.mmoggg.de/
http://www.saferunescapegold.com/
Go to Top of Page

prett
Posting Yak Master

USA
200 Posts

Posted - 03/20/2013 :  06:38:23  Show Profile  Visit prett's Homepage  Reply with Quote
You can fix this issue by restoring updated backup. Please check this link for more information about the error: http://www.sqlservercentral.com/Forums/Topic1356770-1292-2.aspx
Go to Top of Page

pladrounf
Starting Member

3 Posts

Posted - 08/23/2014 :  08:29:25  Show Profile  Reply with Quote
Get it from here http://www.sql.recoverytoolbox.com/
Recovery Toolbox for SQL Server
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.06 seconds. Powered By: Snitz Forums 2000