Restoring a missing or corrupted SQL nonprimary filegroup

Use the following steps to restore a missing or corrupted nonprimary filegroup.

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.

More Information

Restoring an entire SQL database, a missing primary filegroup, or a filegroup containing a deleted or changed table

About restoring SQL databases and file groups

Restoring data by setting job properties