Solved

Fast File Initialization SQL 2008

Posted on 2011-03-04
4
647 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:sqlagent007
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 35039054
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.

0
 
LVL 1

Author Comment

by:sqlagent007
ID: 35040624
What is TDE and how do I grant SE_MANAGE_VOLUME_NAME?

Thanks for your help!
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35058550
The "TDE" is "transparent data encryption" - for more details:
http://blogs.msdn.com/b/sql_pfe_blog/archive/2009/12/23/how-and-why-to-enable-instant-file-initialization.aspx 

you need to check which NT user is starting your SQL server service and grant
SE_MANAGE_VOLUME_NAME to that account.
0
 
LVL 1

Author Closing Comment

by:sqlagent007
ID: 35058566
thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now