My guess is that PSS took one too many calls about
the restore of a single table destroying referential integrity. I dealt with that very issue
myself many times.
Versions 7.0 and beyond now include the ability to back up and restore filegroups.
You can place specific objects on specific filegroups. If you want to back up only one
table, create a filegroup for it and you??™re all set.
nNote Third-party utilities allow table-level restore. However, while they may prove useful, don??™t rely on
them when planning. Assume you have only the native SQL Server tools to use.
Requirements
Perhaps you don??™t need to back up the entire database; you might be able to re-create it
from seed data. Maybe you only need the Order and Order Detail tables. In that case, you
can create a filegroup called Order_FG and place those two tables on it. Since those are the
only tables receiving incoming data, that??™s all you need to back up.
Potential Approach
You should include the PRIMARY filegroup any time you decide to use filegroup backups
(remember, it contains information about the database itself).
Pages:
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274