Fast Database File Creation for Large Databases in SQL Server 2005

Thursday Jul 10th 2008 by DatabaseJournal.com Staff
Share:

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved