Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Checkdb results

Author  Topic 

jdbrown239
Starting Member

1 Post

Posted - 2012-09-11 : 16:43:01
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

1974 Posts

Posted - 2012-09-11 : 16:51:25
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 - 2012-11-29 : 17:59:59
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

4 Posts

Posted - 2013-03-20 : 02:26:13
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

212 Posts

Posted - 2013-03-20 : 06:38:23
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 - 2014-08-23 : 08:29:25
Get it from here http://www.sql.recoverytoolbox.com/
Recovery Toolbox for SQL Server[url][/url]
Go to Top of Page
   

- Advertisement -