Online Documentation for SQL Manager for SQL server

Restore Database

Restore Database Wizard allows you to perform the database restore operation on your SQL Server system (the RESTORE DATABASE Transact-SQL statement is issued).

This operation is used to rebuild a damaged or corrupted database that has been backed up using Backup Database Wizard. You can restore an entire database, part of a database, specific files and filegroups, transaction logs.

To run the wizard, select the Services | Restore Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Restore Database... item of the context menu. Alternatively, you can right-click the Databases node and select the Tasks | Restore Database... context menu item.

• Selecting destination database
• Setting restore type and recovery options
• Selecting backup set to restore
• Selecting files to restore
• Setting advanced restore options
• Running database restore