FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise More

Symptoms


When you use SQL Server Managed Backup to Windows Azure on a database in SQL Server 2014 SP1, SP2, or 2016, the backups that are past the retention period are not deleted according to the retention policy.

Resolution


The issue was first fixed in the following cumulative update of SQL Server:

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.