SQL Server Performance

Clustered Index build errors out.

Discussion in 'Performance Tuning for DBAs' started by csk1970, May 13, 2005.

  1. csk1970 New Member

    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
  2. Luis Martin Moderator

    Did you try drop and create cluster index?

    Luis Martin

    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.

  3. satya Moderator

    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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page