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.