0

I am having an issue creating differential backups of Azure SQL database in storage account blob storage using powershell. I don't know if it is possible or not to get a differential back up of an Azure SQL database. Please suggest me what can I do.

0

1 Answer 1

2

If have seen the differential backup document, you will find this: enter image description here

Azure SQL database has the feature Automated backups. It referred that:

SQL Database supports self-service for point-in-time restore (PITR) by automatically creating full backup, differential backups, and transaction log backups. Full database backups are created weekly, differential database backups are generally created every 12 hours, and transaction log backups are generally created every 5 - 10 minutes, with the frequency based on the compute size and amount of database activity. The first full backup is scheduled immediately after a database is created. It usually completes within 30 minutes, but it can take longer when the database is of a significant size. For example, the initial backup can take longer on a restored database or a database copy. After the first full backup, all further backups are scheduled automatically and managed silently in the background. The exact timing of all database backups is determined by the SQL Database service as it balances the overall system workload. You cannot change or disable the backup jobs.

I also asked Azure Support, they told me that we(customer) can not create the differential backup by ourselves, Azure SQL database will do that automatic.

Hope this helps.

Sign up to request clarification or add additional context in comments.

1 Comment

Hi @Shubhamshukla, Please mark it as the answer. Thank you very much !

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.