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 10: select Overwrite the existing database option and then click on OK button
Step 11: 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.