Restoring Microsoft SQL database

This article explains how to restore a Microsoft SQL database from a backup.

Microsoft SQL database can be restored to its original location or to a new temporary directory.


How to restore Microsoft SQL database from backup

The first step in restoring a Microsoft SQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the Microsoft SQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

circle-exclamation

Once the database files are restored, the next step is to import them into the Microsoft SQL environment.

1

Open the Microsoft SQL Management Studio.

2

Log in to the directory tree, right-click Databases, and select the Restore Database option.

3

In the opened window, select Device as the backup source and provide the path to the folder containing the *.bak database dump file.

4

After selecting the *.bak file, click OK.

5

The database has been successfully restored and is now listed in the directory tree.

Last updated