Avatar of sqlagent007
sqlagent007
Flag for United States of America asked on

Fast File Initialization SQL 2008

Here is my config:
Windows Server 2008 x64
SQL 2008 Standard Edt x64

I have all of the SQL services running under the same domain account, this account is in the "Local Admins" group of windows. When I run the BPA, it tells me that "Fast File Initialization" is not turned on.

Any ideas?
Microsoft SQL Server 2008Windows Server 2008

Avatar of undefined
Last Comment
sqlagent007

8/22/2022 - Mon
lcohan

http://msdn.microsoft.com/en-us/library/ms175935.aspx

Note:
Instant file initialization is available only on Microsoft Windows XP Professional or Windows Server 2003 or later versions.
 

Instant file initialization is only available if the SQL Server (MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME. Members of the Windows Administrator group have this right and can grant it to other users by adding them to the Perform Volume Maintenance Tasks security policy. For more information about assigning user rights, see the Windows documentation.

Instant file initialization is not available when TDE is enabled.

sqlagent007

ASKER
What is TDE and how do I grant SE_MANAGE_VOLUME_NAME?

Thanks for your help!
ASKER CERTIFIED SOLUTION
lcohan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sqlagent007

ASKER
thanks!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23