Recovering a database from read-write 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

  1. Browse for the backup images you want to restore.

  2. In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.

  3. Expand the database that contains the read-write filegroups you want to restore.

  4. Select the transaction log backup.

  5. Right-click the transaction log backup and select Properties.

  6. On the Recovery set tab, verify that a complete backup set is available.

  7. Click OK.

  8. 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

Browsing for backup images

Restoring read-only filegroups (SQL Server 2005 or later)