Post reply

Backup job tied to user account fails.

  • June 11, 2013 at 6:05 am

    #273640

    What's the best practice for setting up maintenance plans? We had a former admin who had set up our backup maintenance plans. The backups stopped occurring when her Active Directory account was disabled.

    Her account was the "owner" of the SQL Server agent job.

    Should we create a service account for the purpose of setting up backups?

    How do you handle this?

  • June 11, 2013 at 6:12 am

    #1622845

    We change the Owner of all our Maintenance Plan jobs to "sa". This works whether the the instance is "Windows Only" or "Mixed Mode". We did this to avoid the exact scenario you have.

  • June 11, 2013 at 9:02 am

    #1622996

    We try to disable/remove SA every where. You can also create a AD service account that way you have a user that can be used every where and given only the OS and SQL rights needed to perform the job.

    We have 6 SQL Ad Service accounts to handle the various aspects of running sql services, jobs, backups, ect.

    Joe

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

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