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


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 schedule and then we will modify the plan to indicat

Altaro backup: installation and use with Hyper-V
In this tutorial, I will explain how to set up Altaro Backup with Hyper-V. Presentation Altaro Backup is a backup solution for virtual environments Hyper-V and VMware running Windows. It has the advantage of being very light and does not require SQL

Windows Backup: installation and configuration
Presentation Windows Server includes a feature (Windows Backup) that allows you to perform full system backups or a portion of it. It can be used to back up virtual machines, SQL Server databases, file server ... It is recommended to use a hard disk

Leave a Comment