how to protect the data loss with database snapshot

  • I have database where continuous changes are happening I do take backups on regular interval bases and also take snapshot manually in between .but how to recover the data loss that can happen in between snapshots and regular backups.what is the best way to protect data then......

  • Start with a solid backup plan that you test regularly. Sounds like your database should be using the full recovery model and that your backup plan should use a combination of full and transaction log backups.

    Then when and how these are run will depend on your RPO and RTO (Recovery Point Objective and Recovery Time Objective). These need to be established based on the needs of your business.

  • there are many ways to handle this..

    1. take regular log backups.

    2. log shipping.

    3. mirroring

    hope this helps.



    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • Snapshots are not primarily there to prevent data loss. Start with a good solid backup strategy, full and log backups.

    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
  • Hello, i have a suggestion for all of you who are looking to data protection services. I recommend everyone two-factor authentication[/url] ,

    I have been using it and I am very satisfied with it. I also have some friends who've been using and they are very satisfied too. Cheers

Viewing 5 posts - 1 through 4 (of 4 total)

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