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
yankeekAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

I suggest that if you really must have the database backed up first, then put it in its own plan, and put the rest in another plan. Then adjust the scheduling to suit.

HTH
  David

PS I use Ola Hallengren's maintenancescript to build my backup jobs.
0
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
You can choose which databases to backup, so you could exclude the database you want to backup last and have a second backup task to backup just that one database.  It might look like: SQL2012Maintenance Plan
0
yankeekAuthor Commented:
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
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
With Ola Hallengrens solution, you can do exactly this.

First fire of a backup with "user_databases" and exclude the one you want special treatment for, and then run Another job, that only backups the excluded database.

Tee frist step vill include any newly created databases.

Regards marten
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yankeekAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.