To restore a missing or corrupted nonprimary filegroup

1. On the navigation bar, click the arrow next to Backup.

2. Click New Backup Job.

3. On the Properties pane, under Source, click Selections.

4. In the backup selections list, select the database.

5. On the Properties pane, under Settings, click Microsoft SQL.

6. Select the backup method Log No Truncate, select None for a consistency check, and then start the backup job.

7. After the Log No Truncate backup is complete, restore the missing or corrupted filegroup by selecting the filegroup backup sets containing the latest full and differential backups, and the transaction log backups.

8. On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

9. Start the restore job or select other restore options from the Properties pane, and then start the restore job.