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


Optimize the space of SQL Server databases
Presentation In this tutorial I will show how to optimize the space used by databases. The optimization of the space is done in two stages: On the database: internal data optimization On files: reducing the size of the files on the disk. It is recomm

GLPI 9.3 convert tables to innodb
Presentation Since version 9.3 of GLPI, the new installations use the InnoDB storage format instead of MyISAM. When updating your GLPI, the tables will not be automatically migrated. The migration must be done by hand. When connecting to your site yo

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 reminder, in normal operation, access to previous ve

Leave a Comment