Recovering a SQL Server database from read-write filegroup backups
NetBackup for SQL Server automatically generates the most efficient recovery path when you select a transaction log image for restore. The recovery path can be based on read-write filegroups if you use them in your backup strategy. After restoring the read-write filegroups, you can bring the database online without having to restore the read-only filegroups.
To recover a database from read-write filegroups
- Browse for the backup images you want to restore.
- Expand the database instance.
- Expand the database that contains the read-write filegroups you want to restore.
- Select the transaction log backup.
- Right-click the transaction log backup and select Properties.
- On the Recovery set tab, verify that a complete backup set is available and click OK.
- Click Restore.