Solved

Fast File Initialization SQL 2008

Posted on 2011-03-04
4
666 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
[X]
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
  • 2
  • 2
4 Comments
 
LVL 40

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 40

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

623 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