SQL Server Performance Forum – Threads Archive
Maintenance Plans FailI have setup several SQL servers, so I am OK with a majority of the problems. I have run into one that I don’t understand. My maintenance plan job keeps failing. When I look at the back files the pack portion is creating, all the DBs backup except master and msdb. I am pretty sure the jobs are failing because of access issues to the master and/or msdb DBs. Why will these backup on the other servers, but not this one? Thanks to anyone that responds.
Are you sure you have selected Master/MSDB database in maintenance plan?
did you select below radio option: – All user databases (All databases other then Master, Model and MSDB)
— Can you explain in little more detail what exactly you want to say/problem is? Deepak Kumar –An eye for an eye and everyone shall be blind
Take help from this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;288577 to troubleshoot the maint.plans. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.