Procedure for Restore of Sqlserver Databases

Restore of Database:


Step 1: Open Sql Server Management Studio and connect the database engine.



Step 2: Enter the To Database name.



Step 3: Select From Device and click on the browse button, then the following window will appear



Step 4: Click on Add Button , then the following window will appear



Step 5: After selecting the backup file the following window appear.



Step 6: Click on OK Button in the above window then the following window will appear



Step 7: Select Restore button and Select Options tab from the above window, the following will appear.



Step 8: Select Overwrite the existing database option and then click on OK button

Step 9: Then you will find the below window says, Restore of database ‘Test’ completed successfully and then click on ok, then go to the database you will find all the tables, views, Stored procedures and etc.