Assume that you create a backup by using compression and checksum on a transparent data encryption (TDE) enabled database in Microsoft SQL Server 2016. In this scenario, you may fail to restore a database from the backup and receive error messages that resemble the following:
Msg 3183, Level 16, State 1, Line 25
RESTORE detected an error on page (1:1314) in database "JUNKTestDB" as read from the backup set.
Msg 3013, Level 16, State 1, Line 25
RESTORE DATABASE is terminating abnormally.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 4019893 - Last Review: Aug 8, 2017 - Revision: 5