Frequency of Backups

How often you back up your databases depends on many factors, including the following:

Image The size of your databases and your backup window (that is, the time allocated to complete the task of backing up the database)

Image The frequency of changes to the data and method by which it is changed

Image The acceptable amount of data loss in the event of a failure

The acceptable recovery time in the event of a failure

First, you must establish ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.