It??™s
always a good idea to take a breath, look around, and stop to think, ???Did I restore all of
the files I needed to restore???? Once that database is recovered, any missed steps mean
you have to start over.
Restoring Differential Backups
As you might have guessed, the process of restoring file differential backups is similar to
that of restoring database differentials. Keep in mind that you must restore a file differential
backup that corresponds to the specific full-file backup you??™re starting with.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 89
The following code restores a single data file, much like the previous sample, but it
also restores a file differential backup before applying transaction log backups:
RESTORE DATABASE AWSample
FILE='D:\DATA\AWSData2.ndf'
FROM DISK='E:\DATA\AWSData2.bak'
WITH NORECOVERY
RESTORE DATABASE AWSample
FILE='D:\Data\AWSData2.ndf'
FROM DISK = 'E:\Data\AWSData2_Diff.bak'
WITH NORECOVERY
-- Continue to restore any application transaction logs
-- Apply the tail-log backup
RESTORE LOG AWSample
FROM DISK 'E:\BackupData\AWSample_TailLog.
Pages:
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196