Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Fast File Initialization SQL 2008

Posted on 2011-03-04
4
655 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

856 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