Create a MSSQL BACPAC Backup

Create a MSSQL BACPAC Backup

To create a BACPAC backup, do the following steps:

  1. Open Management Studio and connect to the database server.
  2. Right click on the database you wish to backup and select Tasks > Export Data-tier Application...

  3. In the dialog that appears click "Next >"

  4. In the Export Settings window select "Save to local disk" and click "Browse..." to select the destination of your BACPAC backup file.
  5. Select your destination and give your file a name, make sure you manually type in the extension ".bacpac"
    Click "    Save"
  6. Confirm your BACPAC file destination and click "Next >"
  7. Review the summary and click "Finish"
  8. Your BACPAC backup is complete!

 


    • Related Articles

    • 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. Open Management Studio and connect to the database server. Right-click on ...

    • 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 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 POSTGRES Backup

      This article assumes that you know your Postgres credentials and PgAdmin is Installed. Connect into PgAdmin. Right-Click on the database and click Backup Click on the folder icon to choose a location for your backup When you reach the location to ...

    • Convert a Postgres database to MSSQL

      Full Convert by Spectral Core is a robust tool for converting databases from one format to another. The following instructions will walk you through using Full Convert to convert a Postgres database to MSSQL. Launch Full Convert Click New database ...