Once you have followed how to backup a MS SQL database you will be ready to restore it. There are two methods of restoring a MS SQL database:
VSS restores can overwrite current live data. During a restore, data is downloaded from the Storage Platform and written to a temporary location on the hard drive. This location is a folder that will temporarily hold the restored data, before it is streamed back into the database from where it was initially backed up.
Therefore, take care when doing test restores as they will overwrite any current data in the database with the data from the restore.
After the data has been restored from the BackupVault Storage Platform it will temporarily be written to disk. The VSS component will then import the data into the live MS SQL server.
A safer and preferred method of restoring SQL databases is to use the File Restore Method. The mdf and ldf files are restored to an alternative location on the server to be attached manually to the SQL server at a later date.
Article ID: 31
Created: Wed, Nov 12, 2014
Last Updated: Sun, Jun 23, 2019
Author: Rob Stevenson
Online URL: https://www.backupvault.co.uk/kb/article/how-to-restore-a-ms-sql-database-using-backupvault-pro.html