Friday, June 20, 2008

Restoring database backup in SQL server 2005

We have seen backing up a database in SQL server 2005, the backup can be restored to get the database to the state in which it was when the backup was taken. The steps are as follows:
  1. Expand the database tab to display all the databases running in SQL server.

  2. Right click the database that has to be backed up and select the "Tasks" option.

  3. 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.

No comments: