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
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.
Right-click the transaction log backup and select Properties.
On the Recovery set tab, verify that a complete backup set is available.
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.
More Information