CODEWITHSUNDEEP
azure-sql-database
sac
sac

Reputation: 215

How to take Incremental backup for Azure SQL db using SQLPackage

I have created a devOps pipeline which executes a task using SQLPackage which takes the backup of our SQL DB in .bacpac file. This export took almost 5 hours to complete. As we are going to take the Production DB backup every night, we want to take only incremental DB backup instead of Full Backup.

Can you please guide me how we can do that using SQLPackage or suggest some other options

Thanks, Sachin

Upvotes: 0

Views: 902

Answers (1)

Kartik Bhiwapurkar
Kartik Bhiwapurkar

Reputation: 5169

Azure SQL Database supports Full backup, Differential backup and Transaction log backup.

Differential backup: - It is based on the latest full data backup. it only collects the data which are changed after the last full data backup. You may routinely backup your database without experiencing the burden of complete database backups.

Azure SQL Database provides automated backups.

Full Data Backup - every week; Differential backup - every 12-24 hours; Transaction log backup- every 5 to 10 minutes.

Reference: - https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql&tabs=single-database

Upvotes: 1

Related Questions