How to Restore Microsoft SQL Server 2012 Database to a File System

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

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.
2. Click Microsoft SQL in the Contents list, and select the Instance:
    
3. Click the database to be restored to see the available revisions:
   

4. Click Restore to the right of the database to restore; the Restore dialog box displays.  Set the following options:

   1. Restore to – Select Original Location
   2. Database name –  Do not change this field
   3. Instance – Select Original Instance

   4. Method –  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:
      

      If you specify a name that is the same as an existing database on the target server, the restore always overwrites the database on that server, even when restoring to an alternate path.

      Flat file restores can only be completed on individual databases. Use an alternate name if you do not want to overwrite the existing database,

5. Click Start Restore. Once the restore is complete, the Success dialog displays; click OK to close the dialog box.

6. Open Microsoft SQL Server Management Studio, right-click Databases, and click Attach:
   

7. The Attach Databases dialog box displays. Click Add:
    

8. Browse to and select the restored .mdf file:
   

9. Click OK to attach the database:
   

10. Click OK to close the dialog box.