Restoring SQL Server filegroup backups

This topic describes how to restore a backup of a filegroup. If you scheduled backups only include read-write filegroups, see the following topics.

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.
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.
Click Restore.

More Information

Recovering a SQL Server database from read-write filegroup backups

Restoring SQL Server read-only filegroups

Staging a full SQL Server database recovery

Browsing for SQL Server backup images

Restoring SQL Server filegroup backups

Feedback

Feedback