I am breaking breaking a 260GB+ database up into filegroups and I want to shrink the original data file. However, the dbcc shrinkfile is erroring out on one of the table objects. DBCC checktable on the table returns 137 errors similar to the following:<br /><br />Table error: Object ID 1952726009. The text, ntext, or image node at page (1:1883003<img src='/community/emoticons/emotion-11.gif' alt='8)' />, slot 43, text ID 4380240052224 is not referenced<br /><br />I believe that this is an indexing error if I am not mistaken, especially since when I tried to build a clustered index on this table, I get a General Network Error and the SQL Server service stops.<br /><br />My question is this: Is this a problem with the base table or with the sysindexes table? Is there a way to recover from this without a restore? I would have to go back to the original 260GB file for the table and that takes about 9 hours from tape backup.<br /><br />Any suggestions appreciated.<br /><br />Thanks,<br />Craig
Did you try drop and create cluster index? Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell All postings are provided “AS IS†with no warranties for accuracy.
True, that is the best option to go and also check the disk holding the data and index files has any hardware issues. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.