SQL Server Restore a Database from a Backup (BAK)

Introduction

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



Related Posts


Exchange 2019: Add a database

Introduction Using multiple databases to store mailboxes allows you to configure a different volume. Example: The DBMX01 database stores mailboxes with a 1GO quota and the DBMX02 database stores mailb

Enable Windows Active Directory Recycle Bin 2012/2016/2019

Introduction The Active Directory Recycle Bin is a feature that came with Windows 2008R2, which is disabled by default. To activate the recycle bin, the domain and drill level must be at least 2008R2.

SQL Server: Set up a backup plan

Introduction In this article, I will explain how to set up a backup plan with SQL Server. In this tutorial, we will use the wizard available in SSMS to configure the database to save as well as the sc

Scroll to Top