| Table of Contents |
|---|
...
Manually Creating a BACPAC Backup (.bacpac)
| Info |
|---|
Before you start NOTE: A bacpac file is generated table by table so you can have no other users or services accessing the database at the time of the export, otherwise the integrity of the final file will be compromised. We highly recommend creating a COPY of the database first, then you can be sure there are no services nor users interacting with the database |
Copy the database
Copy the target database, which will return straight away, but the database will take some time to copy. This operation will create a full transactional copy:
...
| Code Block |
|---|
SELECT * FROM sys.dm_database_copies
--Run this against the master database |
Create a BACPAC with the Jiwa Database wizard
...
Create a BACPAC with Microsoft SQL Server Management Studio
A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from a SQL Server database. A BACPAC file is exported from a SQL Database and can be later imported back into a SQL Database. Backpac's are essential for backing up cloud / Azure hosted databases. They also have the advantage of being smaller in size than a .bak and so are easier to upload or transport.
| Info |
|---|
Before you start NOTE: A bacpac file is generated table by table so you can have no other users or services accessing the database at the time of the export, otherwise the integrity of the final file will be compromised. We highly recommend creating a COPY of the database first, then you can be sure there are no services nor users interacting with the database |
...