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

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.
LVL 10
ThorinOAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
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
 
chapmandewConnect With a Mentor Commented:
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
 
ThorinOAuthor Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
ThorinOAuthor Commented:
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
 
chapmandewConnect With a Mentor Commented:
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
 
ThorinOAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.