Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to make a policy like this:

Step 1: Backup everything in full

Step 2: Come back and do transaction log backups on SQL/Sharepoint (with truncate)

Step 3: Verify Backups.

But when it comes time to select selection lists (upon policy saving) and I select both my "full" backup selection list and my "SQL/Sharepoint only" selection list I get two jobs per step of the policy.

Of course, because of this all my files are backed up twice (since I didn't modify the "general" backup parameters for files, it's still set to "FULL" in the job step. But the intention of that selection list is to ONLY grab SQL/Sharepoint data.

Does that make sense?

share|improve this question

No, a policy is applied to a selection list in its entirety.

What you want is one policy that is just what you want for backing up files, and one policy that is just what you want for SQL.

Then you have two selection lists - one with files in, and the other with SQL databases in. It's obvious which selection list goes with which policy!

This might seem like more work initially, but as your environment becomes more complex, you'll realise that it's much easier this way. You may end up with lots of jobs, but as long as you manage the policies and selection lists, it'll all work out.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.