Step 1. Launch Restore Wizard

To launch the Restore wizard, do the following:

  1. In the navigation pane, select a database.
  2. On the Database tab, select Restore Schema > Restore database schema and data.

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 perform a restore of database schema and data. For more information, see Configuring Staging SQL Server.
  • FILESTREAM must be enabled on a staging SQL Server to restore file tables. For more information on enabling FILESTREAM, see this Microsoft article.

Launching Restore Wizard