Restore a MSSQL BACPAC Backup

Restore a MSSQL BACPAC Backup

BACPAC files are a specialized set of SQL Scripts that can be restored into Microsoft SQL Server using Management Studio.

To restore a BACPAC database, do the following steps.

  1. Open Management Studio and connect to the database server.
  2. Right-click on Databases and select Import Data-tier Application...
  3. If the Introduction page appears, check Do not show this page again then click Next
  4. On the Import Settings page, select Import from local disk then Browse... for the bacpac file and click Next
  5. Provide the New database name and then click Next
  6. On the Database Settings
    1. Give your database a name
    2. Click Next
  7. On the Summary page, click Finish
  8. The database will be created and the BACPAC will be restored into it
  9. On the Results page, click Close
  10. Select Databases and press F5 on your keyboard.
    The database is now visible through Management Studio.

    • Related Articles

    • Create a MSSQL BACPAC Backup

      To create a BACPAC backup, do the following steps: Open Management Studio and connect to the database server. Right click on the database you wish to backup and select Tasks > Export Data-tier Application... In the dialog that appears click "Next >" ...

    • Restore a MSSQL BAK Backup

      To restore a MSSQL BAK database backup, do the following steps: Open Management Studio and connect to the database server. 1. Right-Click on Databases 2. Select Restore Database... In the dialog that appears: 1. Select Device 2. Click the ... button: ...

    • Create a MSSQL BAK Backup

      To create a BAK backup, do the following steps: 1. Shrink the Database (Optional) Open Management Studio and connect to the database server. Change the Recovery Model to Simple: 1. Right click on the database you wish to backup and select Properties. ...

    • Restore a POSTGRES Backup

      Once someone sends you a backup created by following these instructions, you can restore it by following the steps below. Navigate to the location your TAR file is saved at. Extract the TAR File A TAR file is similar to a ZIP file. Using 7Zip, open ...

    • Repair a corrupt MSSQL database

      For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...