Solved

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

Posted on 2011-03-24
6
534 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 500 total points
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 10

Author Comment

by:ThorinO
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

16 Experts available now in Live!

Get 1:1 Help Now