November 18, 2013 at 10:35 pm
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......
November 18, 2013 at 10:43 pm
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.
November 18, 2013 at 10:43 pm
there are many ways to handle this..
1. take regular log backups.
2. log shipping.
3. mirroring
hope this helps.
November 18, 2013 at 11:41 pm
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
March 14, 2014 at 12:04 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy