Create a MSSQL BACPAC Backup
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 >
"
In the Export Settings window select "
Save to local disk
" and click "
Browse...
" to select the destination of your BACPAC backup file.
Select your destination and give your file a name, make sure you manually type in the extension "
.bacpac"
Click "
Save
"
Confirm your BACPAC file destination and click "
Next >
"
Review the summary and click "
Finish
"
Your BACPAC backup is complete!