[SQL Server on Azure VM] Automated Backups run daily when scheduled to run weekly


 When we enable Automated Backup for SQL Server as documented in https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup and if we setup manual schedule with Weekly backup, we will continue to see the backup of the databases happen daily.

 

We had few of our customers report this issue and we wanted to blog about this issue and provide a workaround until the issue is fixed. 

 

There are 2 issues with this, as you see, we do not have an option to select which day of the week you wanted the backup to happen and the other one is with the code issue. This is