How to Restore a Database Backup of SQL-Server Management Studio 2005

Restore Database Backup of SQL -Server

 

  • Restore a Database Backup of SQL-Server Management Studio 2005.
  • Select the Database, which you want to Restore on it. 
  • Right click on the selected Database and go to ‘Task’ tab and select RESTORE option. 
  • Then select Database option. 
  • Database —> Tasks —->RESTORE —-> Database. 
  • After doing this you will have a below screen.
  •  Then Select the From device radio button from Opened windows. 
  • Then Brows the backup file of Database.
  • Set All files option from below screen and then select your backup database file.
  • Select the Database Backup file for Restore Database.
  • After Selecting Database go to the Options Tab, which is located below the General Tab.

 

  • Then check the Overwrite the Existing Database field. 
  • Finally, click OK button to Restore the Database.

 

  •  After completing successfully your task you will have a below screen.

 

  •  Doing this you will restore the database with all the data and stored procedure.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

1 + 5 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">