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.
Wednesday, September 28, 2011
How to make your SQL Server create database files instantly
Subscribe to:
Post Comments (Atom)
0 kommentarer:
Post a Comment