Post reply

Need to add local system account to the perform volume maintenance tasks user rights to turn on instant file initialization

  • November 23, 2010 at 3:05 am

    #149413

    Hi ,

    My sqlserver is running on the local system account. I want to add my local system account to the perform volume maintenance tasks to turn on instant file initialization. But the local system account is not showing there to add to the perform volume maintenance. There are other accounts like system,local service,network service,network. Is the system is local sytem or the local system account is the other one.

    Please let me know.

    Thanks,

    Vamsy

  • November 23, 2010 at 3:49 am

    #1254292

    Can any one please help me on this..

    Thanks,

    Vamsy

  • November 23, 2010 at 3:58 am

    #1254307

    Bumping your post after less than an hour is unnecessary. This is a forum, not a chat room. We're all volunteers here with our own work and problems.

    Be patient.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 23, 2010 at 4:09 am

    #1254315

    @Vamsy,

    If your account is part of the Local Administrators group on Windows, it will have access to Instant File Initialization by default.

    Read this article on how to configure Instant File Initialization. The local account should be listed when you try to add.

    Perform Volume maintenance task properties

    Add User or Group

    Click Advanced

    Click Find Now

    Double click on the account that you want to add

    Click Apply --> Ok

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 23, 2010 at 8:41 am

    #1254511

    You don't need to add local system to that right - it is part of the local administrators group already and has that right by default.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • November 23, 2010 at 11:59 pm

    #1254906

    Thanks Jeffrey and pradeep for your replies

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply