Wednesday, September 28, 2011

How to make your SQL Server create database files instantly

The trick is "Instant File Initialization" - an NTFS feature that, when enabled for the SQL Server service account, creates the database files almost instantly - even with TB of size.

Note that this trick will also reduce your restore time !
How to: http://www.mytechmantra.com/LearnSQLServer/Database_Instant_File_Initialization_Feature.html

Remember that this feature does not work with TDE enabled.