Don??™t get me wrong, I love these products. However, when planning for disaster
recovery, always plan for extremes, which should include not having the presence of third-party utilities.
Backing Up and Restoring Files
Even if you have a single filegroup, you can still back up its individual files. This allows
you to spread out a complete backup over a longer time period, plus it significantly
reduces restore time if a specific data file is damaged. While in Full Recovery or Bulk-
Logged Recovery mode, individual files may be backed up without restriction. In Simple
Recovery mode, only read-only files (implying a read-only database or read-only filegroup)
may be backed up.
Backing up specific files does require more administrative work and detailed documentation
??”much more so than implementing filegroup backups. Also, keep in mind
that you can place tables and indexes only on filegroups, not on specific files. One failed
restore could leave the entire database unusable, whereas a failed filegroup restore may
leave some of the database intact.
nCaution Although SQL Server 2005 and higher offers options for file and filegroup backup/restore while
in Simple Recovery mode, suppress this bit of knowledge.
Pages:
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191