Post reply

Consistancy Error in sysindex, Server:Msg 8964 Level 16

  • November 13, 2008 at 3:09 am

    #193778

    I have a problem in One Database. When i execute DBCC checkdb its throwing error that "Consistancy Error in sysindex, Server:Msg 8964 Level 16" .

    So i have checked the same problem in sql server 2005 express edition but there is no error.

    IS there any one who can tell me what is the Hotfix need to be installed in sql server 2000 so that i can avoid the error in my database?

    Or if there is any solution for this problem pls replay...

    :crazy:

  • November 13, 2008 at 5:01 am

    #897989

    Not sure I understand you fully.

    You have a database on a SQL 2000 server that's giving errors?

    Where does SQL express come in here? A different database attached to the 2005 express instance?

    The error you posted is a corruption message, it's not something a hotfix will fix, it's damage to the database file. Do you have a backup of this database that doesn't have the error?

    If you run the following, what do you get?

    DBCC CheckDB (< Database Name > ) WITH NO_INFOMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 14, 2008 at 1:26 am

    #898440

    Dear ,

    I have one database, i have backup of that database also.

    I have checked all DBCC commands, i am getting same error as i mentioned earlier.

    I have one more server which is running with sql server 2005 express edition. I have restored my backup in sql server 2005 and checked this DBCC checkdb and didn't got any errors. Same backup i tested in sql server 2000 where i am getting error.

    Are you clear now?

    Pls Do some help....

  • November 14, 2008 at 1:58 am

    #898445

    Shripad (11/14/2008)

    Dear ,

    I have checked all DBCC commands, i am getting same error as i mentioned earlier.

    Please post the full output of the checkDB command that I gave above

    I have one more server which is running with sql server 2005 express edition. I have restored my backup in sql server 2005 and checked this DBCC checkdb and didn't got any errors. Same backup i tested in sql server 2000 where i am getting error.

    Same 2000 server or different 2000 server?

    Any errors or warnings when restoring that backup to 2005?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 14, 2008 at 1:23 pm

    #898859

    You've got corruption in the sysindexes table in the 2000 database. As part of the upgrade to 2005, all the system tables are changed and the old ones deleted. My guess is that the corruption is such that CHECKDB finds it on 2000, but it doesn't affect the upgrade process (very rare).

    The error isn't repairable on 2000 at all - best bet is to move to 2005 or to extract all the tables and data out into a new 2000 database.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

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

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