Damaged Database

  • I've got a database that went suspect after a powerfailure, due to an incorrect shutdown procedure.

    I repaired the allocation tables, but some of the indexes are still corrupt. I've tried reparing the indexes with dbcc with no avail.

    When I try to drop the damaged index, drop the table, or select entries from the sysindexes table, I get the following err message:

    error 7105: Page (1:22279), slot 1 for text, ntext, or image node does not exist.

    I,ve got the concered indexes/table in a backup, but not some other tables in the database, which are more recent than the tables in the backup.

    Any ideas of getting rid of the damaged tables and reimporing them, while still preserving the other tables?

    Robert


    Robert

  • Hi,

    I hopw this link may help you.

    http://www.sybase.com/detail?id=1012153

    Madhu


    Madhu

  • Hi.

    Looks like some usefull info.

    Thanks

    Robert


    Robert

Viewing 3 posts - 1 through 2 (of 2 total)

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