Automated Backup for SQL Server 2016 in Azure

Good news for people using SQL 2016 on Azure. Microsoft now support automated backup for SQL Server 2016.
This involve VM running on Windows Server 2012 r2 & Windows 2016 only and does not support SQL 2014 yet.

This new configuration will be available by clicking on SQL Server Configuration as below

sql-server-configuration

You can then, setup SQL Backup for automated backup and chose your frequency/retention…

sql-server-configuration-edit

PowerShell can be use to do the exact same job. For more details please follow the link.

Leave a Reply

Your email address will not be published. Required fields are marked *