Post reply

Question about instant file initialization and non-service accounts

  • January 6, 2015 at 6:06 am

    #299966

    Hello,

    My 3rd party backup product uses a non-service account login to perform tasks. If the account that it uses has been granted Perform Volume Maintenance tasks on the server, will it use IFI when restoring? Or do I need to have it use the service account login specifically to benefit from that?

    Thanks

  • January 6, 2015 at 6:15 am

    #1768056

    Instant file initialisation requires that the SQL Server service account has the 'perform volume maintenance task' permission. The account used to connect to SQL to do the restore is irrelevant.

    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

  • January 6, 2015 at 6:42 am

    #1768066

    Cool, thank you Gail.

Viewing 3 posts - 1 through 2 (of 2 total)

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