sqlagent007
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?
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?
ASKER
What is TDE and how do I grant SE_MANAGE_VOLUME_NAME?
Thanks for your help!
Thanks for your help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks!
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.