SQL Server Restore a Database from a Backup (BAK)

In this tutorial, I will show you how to restore a SQL Server database from a backup file (BAK).

To perform the restore, you must have SQL Server Manager Studio (SSMS).

Restore a database

In order to find the backup files, I copied them to the Backup folder of the SQL Server installation, which is not required. Open SSMS, once connected, right click on Databases 1 and click Restore files and files groups 2 .

Restore options

Select or enter the name of the database 1 , choose the option From the unit 2 then click on the button Browse 3 to choose the file (s).

Restore

Click on Add 1 .

Add file

Select the database backup file 1 and click OK 2 .

Select backup file

Validate by clicking OK 1 .

File selected

Check the box 1 in the Restore column and click OK 2 to restore the database.

Lauch restore

After the database is restored, a confirmation message appears, click OK 1 to close it.

Database restored

Check that the base is present in list 1 , it may be necessary to update the display to see it.

Databases



Leave a Comment