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

Restoring Database Schema and Data

In this article

    To restore database schema and data, 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.
    3. Proceed to Specify Restore Point.

    Restoring 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.

    Restoring Database Schema and Data