Restore Database in SQL Server using BAK

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 the SQL database from the .bak file.

Restore Database in SQL Server using BAK File

As you can see, SQL server does not have the AdventureWorks2017 database

Restore Database in SQL Server using BAK 1

See that the Mdf, and ldf file corresponding to the AdventureWorks2017 are not there in C Drive

TIP: Please refer Backup Database for creating a database backup, and refer Maintenance Plan for creating regular database backups in SQL Server.

Restore Database in SQL Server using BAK 2

We have a Backup file in our D Drive, and we use this file to restore

Restore Database in SQL Server using BAK 3

Right-click on the Databases folder and select the Restore Databases… option.

Restore Database in SQL Server using BAK 4

Selecting the Restore Databases.. option, it will open the following window.

Restore Database in SQL Server using BAK 5

In this example, we want to restore a database from the file system. So, let me select the Device option. Next, click on the … button will open the following window.

Restore Database in SQL Server using BAK 6

Click on the Add button and select the backup file by navigating to the file location.

Restore Database in SQL Server using BAK 7

Click OK to restore the Adventureworks database

Restore Database in SQL Server using BAK 8

Please wait until the restore finished.

Restore Database in SQL Server using BAK 9

Click OK

Restore Database in SQL Server using BAK 10

Now you can see the Adventure Works 2017 database in the Management Studio.

Restore Database in SQL Server using BAK 11

The above process has automatically added the Mdf, and ldf files to the C Drive

Restore Database in SQL Server using BAK 12