If you’re using SQL Server 2019, Transparent Data Encryption, and compressing your database backups, you might be in for a shock. Microsoft released a KB detailing a known bug preventing the restores of these backups. Whilst the latest CU addresses this bug, there’s some important caveats to understand and plan for accordingly.
Read this blog post to find out more.