June 11, 2013 at 6:05 am
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
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
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