bak
MIRROR TO DISK = 'E:\data\AW.bak'
MIRROR TO DISK = 'F:\data\AW.bak'
WITH INIT,CHECKSUM,CONTINUE_ON_ERROR
I??™musing a full backup in the example, but mirrored backups are best suited for
transaction log backups. When in Full Recovery or Bulk-Logged Recovery modes, transaction
logs are critical; being able to immediately back them up to more than one
location plays a huge role in mitigating both media and hardware errors.
CHAPTER 2 n MAKING DATABASE BACKUPS 35
The one restriction to backing up to multiple locations is that the underlying devices
must be identical. In particular, multiple tape drives must all be of the same model from
the same manufacturer.
I don??™t advocate using mirrored backups for full backups, but they??™re a must, not a
maybe, for log backups. You must protect transaction log backups at all costs if you want
to have point-in-time recovery. In my opinion, you can never have enough copies.
Copy-Only Backup
In the introduction to this chapter, I mentioned that you can use backups for purposes
other than disaster recovery. A typical use is to use a backup to move a copy of the database
to a development environment.
Pages:
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110