Home Forums SQL Server 2005 Administering DB Consistency errors RE: DB Consistency errors

  • July 28, 2009 at 3:12 am

    #1030904

    Vishal Singh (7/28/2009)

    For restoring from backups I had to go 15 days back because I have a full backup running everyday (WITN INIT) and the conistency error I found was started 10-14 days back.

    pretty much through...isn't?

    restoring may caused loosing others data (pertty much more than what I lost while repairing with data_loss).

    Then you need to seriously sit down and review both your backup strategy (because it failed you here) and the frequency that you run consistency checks.

    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