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.
Xopero recommends restoring the database files to their original directory to avoid potential permission issues in a different location.
Once the database files are restored, the next step is to import them into the Microsoft SQL environment.
Open the Microsoft SQL Management Studio.
Log in to the directory tree, right-click Databases, and select the Restore Database option.
In the opened window, select Device as the backup source and provide the path to the folder containing the *.bak database dump file.
After selecting the *.bak file, click OK.
The database has been successfully restored and is now listed in the directory tree.
Last updated