Post reply

Data Corruption because of index on system table

  • December 17, 2006 at 11:50 am

    #193448

    Hi,
    Is it possible to drop an index that has been created on system table? It seems such indexes cause DBCC CHECKDB to report error.
    Thanks in advance,
    Amin

  • December 17, 2006 at 1:32 pm

    #678557

    You can create the index on system tables but can't be drop index and you can't run DBCC DBREINDEX against system tables too..

    What table is system table index got corrupted?

    You can try to use undocumented procedure sp_fixindex procedue to repair system indexes...

    http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1118132,00.html

     

    MohammedU
    Microsoft SQL Server MVP

  • December 17, 2006 at 2:00 pm

    #678559

    That was an index on sysobjects table. Sp_fixindex repairs the error but when you create a new object, again dbcc checkdb reports error! You may easily simulate this on a test db.

  • December 17, 2006 at 9:55 pm

    #678569

    Interesting...

    Did you check system log for any disk errors?

    If there is no HW issue, may be option will be calling PSS...

    MohammedU
    Microsoft SQL Server MVP

  • December 17, 2006 at 10:43 pm

    #678570

    No disk error!...

  • December 22, 2006 at 10:48 am

    #679793

    Best option will in this case create newdb and copy the data and rename the db...

    Try applying latest service pack to see what happens after it...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply