Step 1. Launch Restore Wizard

To launch the Restore wizard, do the following:

Alternatively, you can right-click a database in the navigation pane and select Restore schema > Restore database schema and data.

Important

Consider the following:

A staging SQL Server is required to restore database schema and data. For more information, see Configuring Staging SQL Server.
FILESTREAM must be enabled on the staging SQL Server to restore file tables. For more information on enabling FILESTREAM, see this Microsoft article.