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

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:
Recommendation: Install the latest cumulative update for SQL Server

Status

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

Властивості

Ідентифікатор статті: 3169738 – останній перегляд: 25 серп. 2016 р. – виправлення: 1

Зворотний зв’язок