FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


Assume that you enable Transparent Data Encryption (TDE) for a database in Microsoft SQL Server. Then, you back up the database by using a BACKUP DATABASE Transact-SQL statement that has the COMPRESSION and MAXTRANSFERSIZE options specified. If you specify a large value for the MAXTRANSFERSIZE option, the back-up operation may be unsuccessful, and you receive the following error messages:

Resolution


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

Cumulative Update 2 for SQL Server 2017

Cumulative Update 6 for SQL Server 2016 SP1

Cumulative Update 9 for SQL Server 2016

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.