Restore SQL Server filegroup backups (NetBackup MS SQL Client)
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
- Open the NetBackup MS SQL Client.
- 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
Recover a SQL Server database from read-write filegroup backups (NetBackup MS SQL Client)
Restore SQL Server read-only filegroups (NetBackup MS SQL Client)
Stage a full SQL Server database recovery (NetBackup MS SQL Client)
Browsing for SQL Server backup images (NetBackup MS SQL Client)