FIX: Restore of a TDE-compressed backup is unsuccessful when using the VDI client

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Symptoms


Assume that you restore a transparent data encryption (TDE)-compressed backup through SQL Server Virtual Device Interface (VDI) in an instance of Microsoft SQL Server. An integer overflow in the database engine causes the server to issue a large read on the backup file. The VDI client can encounter an end of file(EOF) error because of this read and therefore aborts the restore. Additionally, you receive the following error message on the client:

Resolution


This fix is included in the following updates for SQL Server:

Cumulative Update 7 for SQL Server 2017       

Cumulative Update 1 for SQL Server 2016 Service Pack 2

Cumulative Update 9 for SQL Server 2016 Service Pack 1

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.