We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Backup

How to Restore Microsoft SQL Server 2012 and Above Databases

  • Last updated on

Microsoft VSS is the default backup method for Microsoft SQL 2012 and above. This article applies to customers backing up Microsoft SQL 2012 and above databases using Microsoft VSS. With Microsoft VSS, Barracuda Backup performs full and differential database backups.

Use the following steps to restore a Microsoft SQL Server 2012 or higher database:

  1. Log in to the Barracuda Backup web interface or local UI, go to the Restore > Restore Browser page. Select and expand the SQL server data source in the left pane:
    sql2012_01.png
  2. Click Microsoft SQL in the Contents list, and select the Instance:
    sql_localserver.png
  3. Click the database to be restored to see the available revisions:
    sql_revision.png
  4. Click Restore to the right of the database to restore; the Restore dialog box displays:
    SQL_Server_Restore_dialog.png

    Understanding the Restore Dialog Options

    Restore to is the Destination Server for the restore location. Note that the restore location must be running the same version of SQL Server and the Barracuda Backup Agent must be installed on the location. There are three options to restore to:

    • Original Location is the original server where the backup came from
    • From the drop-down menu, select a different server currently added as a Barracuda Backup data source
    • In the restore field, enter the fully qualified domain name (FQDN) or IP address of a server currently on the network

    Method is the restore method:

    • Select Restore normally to restore to the original location, and write the .mdf and .ldf files back to that location.
    • Select Restore to an alternate location to write the .mdf and .ldf files to a different file path that exists on the source server. Enter the Alternate path, for example, E:\restore, and the Database name in the associated fields. This option must be used if you select to change the database name.

    Select Restore to file system to restore a full database to a file (.mdf/.ldf). Enter the restore file path in the associated field, or leave the default value, for example, C:\Microsoft_SQL_Restore_<date>.

  5. Once you select the location and method, click Start Restore. Once the restore is complete, the Success dialog displays; click OK to close the dialog box.

  6. Restore details are available on the Reports > Restore page:
    restore_report.png

 

Last updated on