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 provided they are not damaged.
To recover a database from read-write filegroups
- Browse for the backup images you want to restore.
- In the Restore Microsoft SQL Server Objects dialog box, 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.
- Click OK.
- To begin the database restore, click Restore.
After the restore completes the database is back online. However, you cannot recover the read-only filegroups until they are restored.