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
- Using templates
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
Yes |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |