bak'
WITH NORECOVERY
RESTORE DATABASE AWSample
WITH RECOVERY
File differentials, just like database differential backups, can dramatically increase
the speed of the restore process. On the downside, file differential backups can make a
backup/restore plan extremely complex (I??™ll discuss that further in Chapter 5).
Backing Up and Restoring Filegroups
File-based backup and restore gives you the most control over individual backup and
restore time. However, since files don??™t necessarily hold entire objects, file-based backup
and restore don??™t give you the greatest level of control over recoverability. That??™s where
filegroups take over.
Tables and indexes are either explicitly or implicitly (via the DEFAULT property)
assigned to a specific filegroup. This allows you to control what objects are backed up
when and how often.
Backing Up a Filegroup
A filegroup backup is really just a shorthand T-SQL method for backing up all the files in
that particular filegroup. The following example shows you how to back up the PRIMARY
filegroup:
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 90
BACKUP DATABASE AWSample
FILEGROUP='PRIMARY'
TO DISK = 'E:\BackupData\AWSFGPrimary.
Pages:
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197