Azure Automated Backup Frequency

0
votes

I have an Azure Windows VM running a few SQL server databases. Azure premium offers automated backup, which is great. I am however not able to change the frequency of the automated backups, which now occur every 2 hours. These 2 hour scheduled backups result in performance issues when the server is running important SQL Server jobs.

Is there any way to alter the frequency other than creating manual backup jobs with the job agent? Within the Azure portal I can only change things like the backup retention, not the frequency.

Thanks in advance!

3
sqldatabaseazurebackupazure-sql-database
Are you talking about Azure SQL or Microsoft SQL in a VM? those 2 are completely unrelated – 4c74356b41
Microsoft SQL inside an (Azure) VM. – ImperialBert
that may be due to the IO's occuring during backups.you can change schedule ,so that they won't conflict with your important jobs – TheGameiswar
So if it is SQL inside a VM you can control it just like a regular SQL server – 4c74356b41

3 Answers

2
votes

It looks like you have a few options with Windows VMs, including something called the Windows Backup Agent. This agent allows you to configure redundancy and backup schedule, along with some other properties that may improve your performance.

Another helpful resource I found was this page which just talks about planning your back approach, along with next steps after you work through this material.

2
votes

Try Cloudberry as a backup tool that works with Azure storage. You can set up the backup time and frequency in the way you want it and that is the most comfortable for you. As far as I see it some third-party backup agent is the best option in your case.

1
votes

If you have your MS SQL server inside Azure VM, you can also use native SQL Server backup tools. Hope this post would be helpful for you.