The longer a mechanical device is in operation or magnetic
media written to, the higher the chance of a failure. All backups should have a
basic goal of completing as quickly as possible.
??? Mirror transaction log backups: In Full and Bulk-Logged Recovery modes, the
transaction log is the lifeblood of the database. A continuous history of transactions
is required for point-in-time recovery. If you lose a single transaction log
backup, that ability is lost. Always mirror transaction log backups.
??? Mirror to multiple physical devices: Whenever possible, be sure to use different
physical devices when using mirrored backups. This means separate RAID arrays,
network locations, or tape drives. Backing up to different drive letters may just be
backing up to the same RAID array; if that array fails, both backups will fail.
??? Beware striped backups: Using multiple physical backup locations and striping a
backup amongst many files can significantly improve performance. However, you
now need every backup file to do any type of restore. Only use this approach if you
need very fast performance and/or if you have a large database (multiterabyte).
Pages:
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118