FIX: Managed Backup Retention-based cleanup task fails because of a query time-out in SQL Server 2014 SP1 or SP2

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

Symptoms


Assume that you enable SQL Server Managed Backup to Windows Azure on a database in Microsoft SQL Server 2014 Service Pack 1 (SP1) or SP2. When the retention-based cleanup task executes the RESTORE HEADERONLY statement on large backup blobs, the execution may time out. Therefore, the retention-based cleanup task fails.

This issue occurs because the default ADO.NET command time-out value is 30 seconds. However, the execution of the RESTORE HEADERONLY statement may exceed 30 seconds. This results in the time-out.

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.