How to: Restore a Backup from a Device (SQL Server Management Studio)

This topic explains how to restore a backup from a device.

To restore a backup from a device

  1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

  2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.

  3. Right-click the database, point to Tasks, and then click Restore.

  4. Click the type of restore operation you want (Database, Files and Filegroups, or Transaction Log). This opens the corresponding restore dialog box.

  5. On the General page, in the Restore source section, click From device.

  6. Click the browse button for the From device text box, which opens the Specify Backup dialog box.

  7. In the Backup media text box, select Backup Device, and click the Add button to open the Select Backup Device dialog box.

  8. In the Backup device text box, select the device you want to use for the restore operation.

See Also


How to: Back Up a Database (SQL Server Management Studio)
How to: Back Up Database Files and Filegroups (SQL Server Management Studio)
How to: Back Up a Transaction Log (SQL Server Management Studio)
How to: Create a Differential Database Backup (SQL Server Management Studio)

Other Resources

SQL Server Management Studio Tutorial

Help and Information

Getting SQL Server 2005 Assistance