Is there any way to choose the databases I want to operate on once in my maintenance plan without having to choose them for each separate task? I have a setup that precludes me from choosing the "All user databases" option.
SnapOverflow
Is there any way to choose the databases I want to operate on once in my maintenance plan without having to choose them for each separate task? I have a setup that precludes me from choosing the "All user databases" option.
No, the sql server team has not implemented custom groups for maintenance plans.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=304835
I left a comment at the bottom a while back - perhaps I should create a suggestions to be able to tag databases to create groups.