Transparent Data Encryption with SQL Server 2016 causing drive space issue

238 Views Asked by At

We are attempting to use TDE with SQL Server 2016 to encrypt a large database. However, when the encryption gets to about 91% we receive a drive space error and the encryption fails. Being that TDE does not cause an increase in the database size, would someone be able to tell me why this is happening?

My only assumption is that a copy of the DB is being encrypted and then the non-encrypted version is being dropped as part of the process. Which means we need to ensure that we have enough available space on the drive to support two .mdf files for the single database. Any insight would be greatly appreciated.

0

There are 0 best solutions below