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 filegroupto 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 applicableto 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 filegroupto select a file group on a target SQL Server instance.

Specifying Additional Restore Options