If you run SQL Server using Network Service accounts, you'll need the following location in Group Policy to allow Instant File Initialization.
Grant 'Perform Volume Maintainence Tasks' to the SQL Server service account as shown below -
http://www.sqlskills.com/blogs/Kimberly/post/Instant-Initialization-What-Why-and-How.aspx
No comments:
Post a Comment