Users then have access to any objects assigned to online filegroups. This
gives you a significant advantage to using filegroups just for the sake of recoverability.
I discussed this functionality while teaching a private SQL Server 2005 class and most
of the students didn??™t see how it was useful. They??™d ask, ???What good is it to have access to
only part of the database???? If you don??™t take this functionality into account when you
construct your filegroups, it won??™t do you any good. But how about a database that has
history tables, such as OrderHistory? By placing those seldom accessed tables on a separate
filegroup, you can have the active tables up and running before the entire database is
restored. If you take these things into account ahead of time, you can drastically increase
the options available to you when designing a backup/recovery plan.
The command to indicate a piecemeal restore is PARTIAL. If you only want to bring
the PRIMARY filegroup back online, you can simply follow your normal restore procedure
but include the PARTIAL clause??”for example:
-- Always backup the tail-log!
BACKUP LOG AWSample
TO DISK='E:\BackupData\AWSample_TailLog.
Pages:
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202