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

Risky Backups

By Steve Jones,

This editorial was originally published on Jan 13, 2009. It is being re-run as Steve is away at the SQL Intersection conference.

The other day I was working in the forums at SQLServerCentral and saw a question about someone doing backups and having issues. While myself and others were trying to help, I recommended that this person not run multiple backups to one file. It's something I've done for years and I've recommended, but the person followed up with a question about why I think it's important.

My first answer was that it's an unnecessary risk. If something happens to the file and you've stored multiple backups in this file, then you lose all the backups. I've seen this happen with older versions of SQL Server and after that time I made it a point to never stick multiple backups in one file. To me it's creating a single point of failure for no reason.

But as I wrote this, I started to question myself a little. I know that some people like having the same filename every day as it makes restores simpler, especially if they've scripted things.  I know that file systems and hardware is often redundant and files are generally safer in the short term than they were in the past, so is my advice outdated?

I still don't think so because in my mind there's a great risk of issues here and that outweighs the convenience. Not to mention that some simple  scripting can make restoring to something like QA easy enough for anyone to run.  However I'm curious what the rest of you think about storing multiple backups in one file.

Steve Jones


The Voice of the DBA Podcasts

The podcast feeds are now available at sqlservercentral.mevio.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

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 www.everydayjones.com.

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: 324 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Podcast Announcements

Podcast Feeds

BLOG

Podcasting

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

BLOG

Podcasting

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

FORUM

Restore multiple Differential backups

Restore multiple Differential backups

BLOG

Community Podcast CALL FOR CONTRIBUTIONS

If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspir...

Tags
backup / restore    
editorial    
 
Contribute

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
Editor, SQLServerCentral.com

Already a member? Jump in:

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