Solved

SQL2012 maintenance plan. DB backup order.

Posted on 2014-07-31
5
300 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 167 total points
ID: 40233909
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 30

Assisted Solution

by:Rich Weissler
Rich Weissler earned 166 total points
ID: 40233917
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
ID: 40234506
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
ID: 40235338
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
ID: 40253898
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

729 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