Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

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
0
yankeek
Asked:
yankeek
3 Solutions
 
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
 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now