BAK'
If you look at the same command created through SSMS, you can see that selecting
PRIMARY implies the backup of each individual file underneath it, as shown in Figure 4-7.
In this example, PRIMARY actually has only two data files??”the third file name shown is a
reference to a full-text catalog that is assigned to that filegroup (more on full-text backup
shortly).
Figure 4-7. Backing up a filegroup is a shortcut to backing up all the files it contains.
Restoring a Filegroup
Restoring a filegroup works the same way most restore operations do. You back up the
tail-log, restore the filegroup (which really means restoring all the files in that filegroup),
restore the tail-log, and recover the database??”for example:
BACKUP LOG AWSample
TO DISK='E:\BackupData\AWSample_TailLog.bak'
WITH NORECOVERY, NO TRUNCATE
GO
-- Always back up the tail-log!
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 91
RESTORE DATABASE AWSample
FILEGROUP='PRIMARY'
FROM DISK='E:\DATA\AWSFGPrimary.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:
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198