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


Sharepoint 2013 foundation: installation and configuration

In this tutorial, we will see how to set up Sharepoint 2013 foundation on Windows 2012R2. Although this version at the time of writing this article is more than 5 years old, it allows to discover Shar

PRTG: equipment dependent on a parent

Introduction PRTG allows you to create dependencies between multiple devices. This allows in case of failure of a device to pass the others automatically paused. This parameter can be used with server

GPO: disable access to previous versions

Introduction In this tutorial, I'll explain how to disable access to previous versions by GPO from client computers. Although convenient, this feature in case of user error can do some damage. As a re