Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Will a differential SQL Server 2008 backup job work this way?

Posted on 2011-03-24
6
Medium Priority
?
555 Views
Last Modified: 2012-05-11
I setup a maintenance plan to just backup databases. I selected only differential, expire after 7 days. It ran for the first time last night and most of the databases were backed up (full). Some however said they failed because they needed a full first. So my questions are as follows:

1. If I run a manual full backup on the databases that did not get backed up will the subsequent differential backups work?

2. Will the old backups be deleted after 7 days or does the expire mean something else? I believe I need to add the maintenance cleanup task to delete files but would like confirmation.

Basically the goal is to always have 7 days of backups, one of which is a full and the rest differential. Nothing more, nothing less, and no manual interaction needed to keep it that way.
0
Comment
Question by:ThorinO
  • 3
  • 3
6 Comments
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 2000 total points
ID: 35207666
1.  Yes.  Differentials and trans log backups have to have a full first, otherwise they've nothing to backup.
2.  Yes, they'll be removed.
0
 
LVL 10

Author Comment

by:ThorinO
ID: 35207689
Most of the databases ran fine and created a full backup, I'm not sure why only a few did not run, do you have any thoughts on that?

2. So the expire will take care of the removal and I don't need the cleanup task?
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 35207755
The cleanup task should take care of it.

The ones that did not run,  you'll just need to take a full backup of them (and make sure you do regular full backups from here out).
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 10

Author Comment

by:ThorinO
ID: 35207780
Can I do full/differential in 1 maint plan or do I have to have full and a diff plan setup and the full go before the diff
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 2000 total points
ID: 35207828
so, a differential is everything that has happened since the last full backup.  So, a full has to be taken before the differential.  

Often, a full backup is take every night or so, and a differential is taken a couple times throughout the day.
0
 
LVL 10

Author Comment

by:ThorinO
ID: 35352850
I created a new job that runs a full and differential, still watching it to see if it is working the way I want.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

971 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