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:

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