How To Restore SQL Server Database From backup
Step-1: Open SQL Server Management Studio and click on Connect from Connect to Server window.
Step-2: Right click on Databases and click on Restore Database…
Step-3: Select Device radio button and click on […].
Step-4: Click on Add button from the Select backup devices window.
Step-5: Select the backup file(AdventureWorks2014.bak for this demo) from the destination and click on OK button.
Step-6: Click on OK button from the Select backup devices window.
Step-7: Click on Files from the left pane of Restore Database window, and provide the path(default path is in the c drive where you installed the SQL Server) for Restore by clicking on […] from data and log files.
Step-8: The database will restore and a popup window will appear as shown in the figure below. Click on Ok button.