Restore Backup File in SQL Server 2008 R2

Sponsored Links

How to restore backup file in SQL Server 2008 R2. Step-by-Step.....

1. Right Click into Database Folder in Sql Server.

2. Click on Restore Database Option.

3.  You will get Restore Database Wizard.

4. Select From Device Option. And Click on To Database Where you want to Restore your Backup File.

5.  Now you have to Add the Backup Location.

  6.  Select Backup file from locate Backup File.

 7.  Now click on OK.

8.  Select To Database Option.

9.  Now Select the Backup file with you attached.

10. Click on Ok.

Restore Process is done Now you can use your Database.......

Sponsored