This is an archive version of the document. To get the most up-to-date information, see the current version.

Step 1. Launch Restore Wizard

To launch the Restore wizard, do the following:

In the navigation pane, select a database.
On the Database tab, select Restore Schema > Restore database schema and data or right-click a database 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.