Home Forums SQL Server 2008 SQL Server 2008 High Availability understanding the need of database snapshot RE: understanding the need of database snapshot

  • November 6, 2013 at 4:00 am

    #1664379

    sej2008 (11/6/2013)

    What I want to know is what steps should be taken to protect any data loss in between the snapshots that we take along with routine backup and restore task as data keep changing constantly in real time environment.

    Thanks in advance

    To be honest I wouldn't use snapshots that way. Protecting against data loss is what your backups are for.

    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