February 9, 2011 at 12:55 pm
I have 50 databases in a SQL Server 2005 maintenance plan. Is there any way to temporarily deselect just one of those databases without choosing Specific Databases in the Maintenance Plan Task and manually selecting the other 49 databases to run except for the one I want to exclude. I guess I'm looking for "Select All User Databases except this one." Is this possible?
Thanks,
Dennis
February 9, 2011 at 2:06 pm
Unfortunately this is one of the many limitations of Maintenance Plans.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 9, 2011 at 2:31 pm
Only if the database is unavailable or offline, you can set the option for that. But you only have the choice of all or select which ones, there is no capability to do all but this one..
CEWII
February 9, 2011 at 5:06 pm
As soon as you need to start taking direct control over what is running within Maintenance Plans, you've just out-grown them. This is actually kind of a great moment. Now you can learn the details of how this work is done and you can fine tune the processes to run more the way you want.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 9, 2011 at 5:13 pm
^ What Grant said. 🙂
I personally prefer individual scripts and jobs for my backups (and maintenance in general) to fine tune my control... and to make sure backup #23 failing doesn't mean the rest of my system is hosed.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply