Printed 2017/08/21 04:51AM

Instant File Initialization with TDE

By Tim Radney, 2012/11/13

If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization.

Microsoft does not provide many details around the reasoning why but I would have to assume that since data is encrypted at the page level, that TDE has to still zero out the file. You can read what Microsoft has to say on TDE here


Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.