Restore Database using SQL Server Management Studio
Follow the steps below in order to restore database.
Login to SQL Server Management Studio as Windows Authentication.
After connecting to the Object Explorer. On the left, select/expand Databases and find your Database name.
Right click on your database and go to Tasks -> Restore -> Database
Select From device and click the small grey box on the right labeled. A window will pop up, Click Add and browse to the location of your .bak file. Click OK.
After that Go to the Options (top-left).
Check Overwrite the existing database.
Click OK to begin the database restoration.
Enjoy...
