O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required