Restoring SQL Server filegroup backups
This topic describes how to restore a backup of a filegroup. If your 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.
Note:
- Browse for the backup images you want to restore.
- In the Restore Microsoft SQL Server Objects dialog box, expand the database instance and database.
- Select the restore options.
- Click Restore.
To view the progress of the restore, select File > View status.