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 Database to a File System

  • Last updated on

This article refers to version 6.3 and higher, and Microsoft SQL Server 2012 and above databases.

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:
    sql_localserver.png 
  3. Click the database to be restored to see the available revisions:
    sql_revision_filesystem.png
  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:
      SQL_FileSysRestore.png

      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:
    attach.png

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

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

  9. Click OK to attach the database:
    attach03.png

  10. Click OK to close the dialog box.

Last updated on