Step 8. Specify Additional Restore Options

At this step of the wizard, specify additional restore options and click Restore.

  • In the Filegroups section, select how filegroups should be restored for selected schema objects:
  • Preserve filegroup if applicable

To preserve the file group state.

  • Use the following filegroup

To select a file group on a target SQL Server instance.

For more information on filegroups, see Microsoft Docs.

  • In the Partitioned tables section, select how partitioned tables should be restored:
  • Preserve partition schema if applicable

To restore tables to the original partition schema.

  • Use the following partition schema

To select a partition schema on a target SQL Server instance.

  • Use the following filegroup

To select a file group on a target SQL Server instance.

Specify Additional Restore Options