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.