Does the LocalSystem account have the right/permission for Instant File Initialization?

Question

If LocalSystem is the account used for SQL Server service, does it mean that Instant File Initialization is enabled automatically?

Answer 1

Yes, it does.

---

Jonathan Kehayias | Senior Consultant, SQLSkills.com
SQL Server MVP | Microsoft Certified Master: SQL Server 2008
Feel free to contact me through My Blog or Twitter
Please click the Mark as Answer button if a post solves your problem!

Answer 2

Hi As Guru Jonathan said, yes it has the permissions.

Further just add more about it :

If the SQL Server service is running under local system account, then you cannot revoke this right. If it is running under a domain account or as a local account which is not part of the Administrators group, then you will need to add this right

http://www.sqlservice.se/tips/instant-file-initialization-pros-and-cons/

 

---

Regards Gursethi Blog: http://sqlfundas.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++

Answer 3

This is documented in BOL - http://msdn.microsoft.com/en-us/library/ms175935.aspx

---

Thanks, Leks

Answer 4

Based on this http://msdn.microsoft.com/en-us/library/ms175935.aspx, Windows Administrator group has the SE_MANAGE_VOLUME_NAME right.  However, what does SE_MANAGE_VOLUME_NAME (disabled) in this page http://msdn.microsoft.com/en-us/library/ms684190(VS.85).aspx mean?