Step 1. Launch Restore Wizard

In this article

    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 or right-click a database and select Restore schema > Restore database schema and data.


    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.

    Restoring Database Schema and Data