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
Thursday, June 18, 2009
Group Policy to Enable Instant File Initialization
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment