Online Documentation for SQL Manager for SQL server
Restore a database from a backup
Use the Restore Database Wizard to restore a database from a backup. To launch the wizard and set restore options choose the Services | Restore Database main menu item.
Using this wizard you can define the necessary restore parameters, such as database to restore, restore type (Database, Transaction log, Recovery without restore or Recovery from database snapshot), recovery options, backup media to restore a database from, database files, and some other options.