October 31, 2007 at 9:08 am
I am running SQL Server 2005 SP2a, and have noticed 2 issues with my Maintenance Plans:
1) I have a Transaction Log backup set up to only back up certain databases. I have no issue with manually adding a new DB every time one is created. Howevr, whenever I modify the step, it clears all of the already selected dbs and I have to go back and manually choose them all again. This does not occur with the corresponding Full database backup step.
2) My Maintenance Plans are failing, because the plan is still looking for databases that have already been deleted. They do not appear in the drop-down, of course, so I can not de-select them:
As follows:
Back Up Transaction Logs (M011)
Backup Database on M011
Databases: (Database names edited out here)
Type: Transaction Log
Append existing
Task start: 2007-10-31T06:55:44.
Task end: 2007-10-31T06:55:45.
Failed:(0) One or more selected databases no longer exist on server.
Back Up Transaction Logs (M011)
Backup Database on M011
Databases: (Database names edited out here)
Type: Transaction Log
Append existing
Task start: 2007-10-31T06:55:44.
Task end: 2007-10-31T06:55:45.
Failed:(0) Database '(name edited out)' is not valid to be included in the maintenance plan.
October 31, 2007 at 9:18 am
I think I noticed #2 as a bug. The task actually builds the code at runtime and if you delete the databases, you can't undo this. I believe you need to remove and add a new task back in. I'd also report this on "ConnecT" as a bug.
You could try viewing the T-SQL and checking what's in there. It might force a regeneration.
If you uncheck the box before you delete the database, you should be ok.
Haven't seen #1, but that should be a bug if it's happening. Does it happen on multiple clients"
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 31, 2007 at 9:33 am
Happens on all Clients.
I'll view the code and see what I see. Maybe I will just wind up trashing and re-creating them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply