The longer the time between full backups,
the more changes in your differentials.
??? A differential backup is directly tied to a specific full backup: Performing an ad-hoc
full backup outside of the normal backup schedule can render a differential backup
useless.
??? Thoroughly examine the frequency of differential backups when establishing
a backup plan: When the database changes frequently, differential backups can
consume a significant amount of space. Be sure to balance the necessary recovery
speed of the database with the available space. If the recovery speed isn??™t a concern,
you don??™t need to use differential backups.
nNote When discussing backup methods with server/network staff, clarify the distinction between a differential
backup and an incremental backup. Many file server backup applications include both a differential
and an incremental mode; the differential includes all of the data that has changed since the last full backup,
while the incremental includes all of the data that has changed since the last differential or full backup. SQL
Server has no direct equivalent to an incremental backup.
Pages:
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101