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 can I restore a Microsoft SQL database to a flat file (.bak) from the Barracuda Backup Service and then back into the system using SQL Management Studio?

  • Type: Knowledgebase
  • Date changed: 2 years ago
Solution #00005949

This solution applies to the Barracuda Backup Service, Microsoft SQL Database restores (2008 and prior, or VDI based 2012), and the SQL Management Studio.
This is NOT for VSS based 2012+ SQL backups.

The following steps will allow you to restore the SQL database to flat-file format (.bak) to a particular path, and then restore the database to working condition using SQL Management Studio:

Restoring the flat-file from the Barracuda Backup Service:
  1. Stop the Barracuda Backup Agent on server from Services MSC.
  2. On a server that has the same version of SQL as the backup installed, edit the bbconfig.ini file within the agent install dir.
    • The bbconfig file is located at C:\Program Files\Barracuda\Barracuda Backup Agent\config
  3. Add these lines:
    • [Microsoft SQL Server Agent]
    • restoreToFilePath=<path>
    • (Where <path> is the path you want it restored to)
    • (If SQL 2012, DO NOT REMOVE SQLVSSVERSION=20 from the config file)
  4. Start the Barracuda Backup Agent on server from Services MSC.
  5. Go to the Restore Browser and drill down till you get to the database you wish to restore. Restore the revision of the database to the server you edited in the previous steps.
  6. The database will be restored down to the server as a .bak file. If the restore is from an incremental backup each backup will have a separate .bak file that can be imported back into SQL.

Restoring the flat files into SQL Management Studio:
  1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
  2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
  3. Right-click the database, point to Tasks, and then click Restore.
  4. Click the type of restore operation you want (Database, Files and Filegroups, or Transaction Log). This opens the corresponding restore dialog box.
  5. On the General page, in the Restore source section, click From device.
  6. Click the browse button for the From device text box, which opens the Specify Backup dialog box.
  7. In the Backup media text box, select Backup Device, and click the Add button to open the Select Backup Device dialog box.
  8. In the Backup device text box, select the device you want to use for the restore operation.