Steve Park (5/7/2009)
Not sure, since I didn't remove them. However I would have figured that if a database was removed then it would cascade to the maintenance plans. However I guess not. I am going to try to remove the maintenance plan and recreate it to see if that fixes the errors.
No - don't remove the maintenance plan. Just modify each task and re-save it to update the list of databases. When you create a maintenance plan, and select a set of databases - that set is saved in the plan. Removing a database does not 'cascade' - so the original maintenance plan is trying to backup a database that no longer exists.
Like I said - just open the task and resave the plan. That should remove the old databases.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs