Solved

SQL2012 maintenance plan. DB backup order.

Posted on 2014-07-31
5
283 Views
Last Modified: 2014-08-11
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
Comment
Question by:yankeek
5 Comments
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 167 total points
Comment Utility
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
 
LVL 29

Assisted Solution

by:Rich Weissler
Rich Weissler earned 166 total points
Comment Utility
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
 

Author Comment

by:yankeek
Comment Utility
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
 
LVL 20

Accepted Solution

by:
Marten Rune earned 167 total points
Comment Utility
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
 

Author Comment

by:yankeek
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now