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.
| 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 1The 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 1Page (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 |
 |
|
|
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. |
|
|
|
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/ |
|
|
|
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 |
|
|
|
pladrounf
Starting Member
3 Posts |
|
|
|
|
|
|
|
Checkdb results