- Expand the database tab to display all the databases running in SQL server.
- Right click the database that has to be backed up and select the "Tasks" option.
- In the "Tasks" option the Restore database option has to be selected.
The below screen comes up after selecting the option.
The database that has to be restored is to be slected in the to database menu.The time upto which the restoration has to be done can be selected based on the type of backup that was taken earlier.The source and location from which the backup data can be obtained has to be specified. The options tab provides various Restore options and Recovery states which are selected based on the needs of a particular restore operation.