Creating File-Specific Differential Backups
Once you back up an individual file, you can create differential backups of just that file.
File differential backups can result in a fast backup (since only the pages that changed
since the last full-file backup are recorded) as well as a fast restore. Keep in mind that the
size of the file differential backups will continue to grow in size (assuming that additional
data is added) until the full file is backed up again.
The following example creates a file differential backup of the file that I backed up in
the previous section:
BACKUP DATABASE AWSample
FILE='D\Data\AWData2.NDF'
WITH DIFFERENTIAL
TO DISK = 'E:\BackupData\AWData2_Diff.BAK'
Look at file backups and file differential backups as a sort of individual database
backup scheme. The only thing to keep in mind is that files don??™t necessarily contain
entire objects. Also, to avoid mass confusion and eventual insanity, use either file differential
or database differential backups??”not both.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 88
Restoring Database Files
Assuming that a single file has been damaged, restoring it is similar to a standard restore
process.
Pages:
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194