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