10.3. Backup options
SQL Server 2008 includes a rich array of options that can be employed as parts of a customized backup and recovery strategy. In this section, we'll consider three such options: checksums, backup mirroring, and transaction log marks. But before we cover these options, let's have a look at an important part of any backup strategy: the backup location and retention policy.
10.3.1. Backup location and retention policy
A key component of a well-designed backup strategy is the location of the backups: disk or tape (or both). Let's consider each of these in turn before looking at a commonly used backup retention policy.
Tape
Historically, organizations have chosen tape media as a backup destination in order to reduce the cost ...
Get SQL Server 2008 Administration in Action 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.
