Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Safety in Numbers

By Steve Jones, I saw a thread on SQLServerCentral where a DBA was looking for a script that would remove all the log backups that had occurred prior to his last full backup. The reasoning was that once a full backup had taken place, and log backups prior to that point weren't needed.

Backup and recovery is the core of what a DBA is responsible for and I thought this would make an interesting Friday poll.

How much backup data do you keep?

I realize that the requirements of different systems might affect this, but as a general rule, how much backup data do you keep? Can you go back to the last full? Two full backups? Something else? I've typically kept two full backups (the most recent and the one before that) along with the  log backups between them, just in case. I haven't kept more than one differential since by definition you don't usually need more than one.

I am sure that requirements for some of you might dictate more backups, but I'm curious as to what you might keep. I am not talking about tapes offsite, since those are usually stored by some corporate standard. I've often had 30 days worth of backups on tape along with yearly, and possibly quarterly or monthly backups kept for years.

I consider myself a fairly cautious DBA, but perhaps not. Is two full backups  on disk enough of a safety net? Let us know this Friday.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 109 | Views in the last 30 days: 1
Related Articles


A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...



I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...


Podcast Announcements

Podcast Feeds


Podcast Problem

Podcast Problem Blocked by group policy


Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...

backup / restore    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones