Automated backup is all about peace of mind, allowing you to recover your databases to any point in time. New enhancements to this feature extend your control over backups when running SQL Server 2016 in Azure Virtual Machines.
“Automated backup now allows you to schedule a time window and frequency, daily or weekly, for full backups so that these don’t impact performance during business hours. In addition, you can specify how often to take log backups,” writes Ninar Nuemah, a program manager for Azure SQL.