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 |
|
shelendra
Starting Member
1 Post |
 Posted - 2008-07-15 : 06:17:49
|
| Hi,I was trying to export a table from one database to other database and got the error that there is some consistancy issue in this table.Then I run DBCC checktable on this table and got this error.DBCC results for 'Message'.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 2060078625, index ID 1, partition ID 72057594151567360, alloc unit ID 72057594992132096 (type LOB data). The off-row data node at page (0:327792), slot 2560, text ID 2672658350080 is referenced by page (1:2578299), slot 17, but was not seen in the scan.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 2060078625, index ID 1, partition ID 72057594151567360, alloc unit ID 72057594992132096 (type LOB data). The off-row data node at page (1:7571678), slot 5, text ID 2672658350080 is not referenced.Msg 8929, Level 16, State 1, Line 1Object ID 2060078625, index ID 1, partition ID 72057594151567360, alloc unit ID 72057595046789120 (type In-row data): Errors found in off-row data with ID 2672658350080 owned by data record identified by RID = (1:2578299:17)There are 4084720 rows in 167859 pages for object "Message".CHECKTABLE found 0 allocation errors and 3 consistency errors in table 'Message' (object ID 2060078625).repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (Blog.dbo.Message).DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-15 : 07:10:41
|
| Is there a question there?First things first, do you have a backup?--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
|
|
DBCC Checktable issue