??? Hardware: One of the key purposes of using filegroups is separating I/O, so using
multiple RAID controllers, channels, or arrays to house separate files or filegroups
can drastically reduce recovery time??”that is, if you??™re lucky enough not to lose the
hardware where the log backups reside.
??? Media: As with hardware failures, using file or filegroup backups can drastically
reduce the restore time if separate media groups are used. This caveat applies not
only to on-disk backups but also to tape backups.
??? Process: The restore process can be reduced if tables and indexes are strategically
placed. For example, if you??™re updating a specific table, you could back up the filegroup
that owns it, run the procedure, then restore the backup if the procedure
fails.
??? User: Again, if designed properly, you might be able to restore only the affected filegroup
in the event of a user error. The user error still can end in data loss, but the
impact may not be as great.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 96
Caveats and Recommendations
Performing filegroup or file backup/restore operations can be fraught with missteps if
you don??™t take care.
Pages:
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206