Post reply

Instant file initialization enable SQL 2K8 R2 64 bit?

  • January 20, 2012 at 5:22 am

    #254029

    Hi,

    Does Instant file initialization this feature should be enable in SQL 2k8 R2 64 bit edition? SQL service account running under Network Service Account

    this is used for Volume Maintenance tasks, and zero out initialization during restore time.

    thanks

    ananda

  • January 20, 2012 at 5:40 am

    #1436401

    It will if you ensure that the Network Service Account belongs to the following user rights assignment: Perform Volume Maintenance Tasks, through group policy.

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

  • January 20, 2012 at 5:45 am

    #1436404

    Thanks for your reply..

    Does Network service account can be support for this lock page memory option? I am using windows 2008 R2 enterprise 64 bit edition.

    thanks

    ananda

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

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