In this article we will show you, How to restore Database in SQL Server using BAK file. For this demonstration, we are going to use the SQL Server management Studio to restore SQL database from .bak file.
TIP: Please refer Backup Database for creating a database backup, and refer Maintenance Plan for creating regular database backups.
Restore Database in SQL Server using BAK File
As you can see, SQL server does not have the AdventureWorks2017 database
From the below screenshot, you can see that the Mdf, and ldf file corresponding to the AdventureWorks2017 are not there in C Drive
We have a Backup file in our D Drive, and we are going to use this file to restore
Right-click on the Databases folder, and select the Restore Databases.. option from the context menu.
Clicking the Restore Databases.. option will open the following window.
In this example, we want to restore database from the file system so, let me select the Device option. Next, click on the … button will open the following window.
Click on the Add button, and select the backup file by navigating to the file location.
Click OK to restore the Adventureworks database
Please wait until the restore is finished.
Click OK
Now you can see the Adventure Works 2017 database
The above process has automatically added the Mdf, and ldf files to the C Drive
