Instant File initialization now works against the log file – with caveats.
Instant File Initialization
Background In a previous article I showed how to detect if Instant File Initialization (IFI) has been set. If IFI isn’t set and is required then the following steps are needed (this example uses Server 2012 R2).
![[url=http://www.cartoonbucket.com/cartoons/road-runner-teasing-wile-e-coyote/][img]http://www.cartoonbucket.com/wp-content/uploads/2015/07/Road-Runner-Teasing-Wile-E.Coyote-600x489.jpg[/img][/url]](https://sqlramblingdotnet.files.wordpress.com/2017/06/road-runner-teasing-wile-e-coyote.jpg?w=900)
BackgroundWhen SQL Server extends data or log files it fills the newly-acquired space with zeroes, to overwrite any data that may have been there beforehand. This action takes place when a database is created, restored, files are extended or added.This can take a long time, depending upon the amount of space being initialised. This is …
Notes on SQL 