Fast Database File Creation for Large Databases in SQL Server 2005

Thursday Jul 10th 2008 by DatabaseJournal.com Staff

This article describes how to enable Instant File Initialization in SQL Server 2005.

[From SQL Server Performance]

The time needed for creating large and very large database can often take many minutes. SQL Server 2005 has a new feature called Instant File Initialization (IFI) that can speed up the data file initialization of a database.

The article continues at http://sql-server-performance.com/articles/dba/Fast_Database_File_Creation_p1.aspx

Mobile Site | Full Site