How to Restore Backup of the Sql Database

How to restore database in Sql Server 

Step 1: First you can open the Sql server and Click on the database as following



Step 2: when you click on Restore Database following dialoge open then you select From Device option  because you cab select backup from external device as following image,



Step 3: Now you double click on From Device option the following dialoge can be open,



Step 4: Now you  can click on add button the following database backup select dialog can be open & you can select backup whatever you cab want to restore.



Step 5: After Selecting Backup you can click on Ok button



Step 6: Now you can click on Add Button  and see the following dialog,



Step 7: Now, Select Restore Option and give database name and then click on Ok Button the Database can be restore successfully as the following,


Previous
Next Post »

1 comments:

Write comments
Pratik Patel
AUTHOR
26 November 2015 at 12:22 delete This comment has been removed by the author.
avatar