Link to home
Start Free TrialLog in
Avatar of yankeek
yankeekFlag for United States of America

asked on

SQL2012 maintenance plan. DB backup order.

Hey all.
I have built a maintenance plan using the built in wizard on my SQL 2012 box.
Is there a way to reorder the database backup flow? ie I want to make the 7th database moved to the 1st to be backed up.

I don't see anything relating to that in the plan designer.

Thanks team
Ken
SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yankeek

ASKER

Good suggestions. I already thought of that.
I like that the option of "ALL DATABASES" on the "Back up database" task. That way if new ones are created or deleted, I don't have to monkey with the maintenance plan.

I just didn't know if anyone knew how to change the order of which database is backed up in what order in the plan.

Ken
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yankeek

ASKER

Thanks for the responses.
I was trying to avoid breaking up the plan. I like the option of "ALL DATABASES" in the plan step. I wish there was a way to order the backup of databases. (Table hack or something)

I have put the big databases in their own plan, and now will have to monkey with the plan whenever a new database is added.
Thanks for the suggestions.
Ken