Restoring filegroup backups
You can periodically back
up only read-write filegroups as a part of your backup strategy. If
periodically is the method you use, see the instructions for that
type of restore.
Information is also
available for how to restore read-only filegroups.
Note:
|
If
you attempt to restore a single differential backup without first
restoring the preceding database backup file, SQL Server halts the
load process. An error such as 4305 or 4306 is displayed. If you
plan to restore a single differential, then you are responsible for
first restoring the database backup file. You can avoid this
problem by backing up the entire sequence of transaction logs. Also
back up the differential backup and the backup file to the same
NetBackup server. Then you can restore the entire sequence of
backup objects.
|
To restore a filegroup backup
-
Browse for the backup
images you want to restore.
-
In the Restore Microsoft SQL Server Objects dialog box,
expand the database instance and database.
-
Expand the filegroup and select a filegroup image
to restore, as follows:
-
To restore a full backup, select the image of the
filegroup backup.
-
To restore a differential filegroup backup, click
the "+" next to the full backup and select the differential
backup.
-
Select the restore
options.
-
Click .
To view the progress of
the restore, select File > .