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 ...

    • Create a Secondary SA (Admin) Account for MSSQL

      In the event that you have lost or forgotten your SQL administrator password, the following script can create an additional administrator SA user account that you can use to log in. This is preferable over resetting the SA password because changing ...