yankeek
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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