Restoring Backup Exec filegroup backups

With filegroup backups, you can restore the entire database, a primary filegroup, a filegroup that contains a deleted or changed table, and a nonprimary filegroup.

Note:

Use separate restore jobs to restore the primary filegroup, the rest of the filegroup backup sets, and the transaction logs.

To restore a SQL filegroup from a Backup Exec image

Log on as Administrator.
Open the Backup, Archive, and Restore interface.
Specify the appropriate server, client, and policy type.
Select File > Select Files and Folders to Restore > from Backup Exec Backup.
In the Restore window, from the NetBackup History pane, select the backup image that contains the objects you want to restore.
In the All Folders pane, select the full backup of the primary filegroup and any differential backups.
Select Actions > Start Restore of Marked Files.
In the Restore Marked Files dialog box, from the Recovery completion state group, select Leave database nonoperational but able to restore additional transaction logs.
Click Start Restore.
After the primary filegroup is restored, select the latest full and differential backups for the other filegroups.
On the Microsoft SQL Server tab, select the recovery completion state Leave database nonoperational but able to restore additional transaction logs, and then start the restore job.
When the other filegroups are restored, select the transaction logs.
On the Microsoft SQL Server tab, for the recovery completion state, select Leave database operational and restore all of the transaction logs.
Optionally, you can also select Point in time log restore or Restore log up to named transaction.
Click Start Restore.