• imtiazm (2/11/2010)


    The database is still suspect , so i can put into emergency mode and access the data.

    It's highly unlikely that you're going to get all the data back. Between the damage to the system table and the corrupt allocation page, there's a good chance that some of the data will be inaccessible even in emergency mode.

    You also need to look at your backup strategy. Any database, regardless of what it is, that is used by the business must be backed up.

    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