Solved

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

Posted on 2011-03-24
6
543 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
[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
  • 3
  • 3
6 Comments
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 500 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 500 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

636 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