How to restore MS SQL database from backup?

This article contains information on how to restore the Microsoft SQL database from a backup.

How to restore the Microsoft SQL database from the backup?

The first thing, you need to do to restore the Microsoft SQL database from the backup is to restore the database files from the storage to the temporary directory, from which these will be imported to the Microsoft SQL database environment.

Read the following article to get information on how to restore files backed up using a file-level backup plan.

File-level backup recovery

If you backed up your database using the image-level backup, use the granular access to the image-level backup using the following article:

Granular Recovery Of Files & Folders - iSCSI Restore

Xopero recommends restoring the database files to the original directory! The reason for this is the possibility of problems with permissions to another location.

The next thing you need to do, when the database files are restored, is to import these files to the Microsoft SQL environment.

To import the restored database dumps files, open the Microsoft SQL Management Studio. Log in to the directory tree, right-click on "Databases" and select the "Restore Database" option.

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

After selecting the * .bak file, choose OK.

The database was successfully restored and is listed in the directory tree.

Last updated