• rspskumar-704119 (1/17/2010)


    plese set db status to emerngy mode and export data and run repair

    Absolutely not. Totally unnecessary and frankly in this case stupid things to suggest.

    Emergency mode is a last resort for when the database is in suspect or recovery pending mode. Not for when the database is online and usable with minor corruption.

    Export (and subsequent re-import) is for when there's irreparable corruption, like damaged allocation pages. This corruption is perfectly repairable (albeit with minor data loss) and hence there is no need whatsoever for something as extreme as export and reimport.

    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