http://www.sqlservercentral.com/blogs/timradney/2012/11/13/instant-file-initialization-with-tde/

Printed 2014/10/22 03:44AM

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

Share


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.