Paul S. Randal Posts Some Sobering Statistics

  • Article

Paul’s name should be familiar to denizens of the SQL Server blogosphere. Along with his wife, Kimberley Tripp, he’s a principal of SQL Skills (home also to the redoubtable Bob Beauchemin, with whom I share a birth date of significance to SQL Server aficionados); given that his history includes authorship of DBCC in SQL Server 2000 and major components of DBCC in SQL Server 2005, the name of his blog is among the great puns out there: In Recovery... | Paul S. Randal on SQL Server.

Paul’s a great guy, and if you haven’t caught one of the presentations he and Kim give, you’re definitely missing out. These folks are two of the finest SQL Server presenters in the world. No wonder they’re found at the center of the MCA and MCM Database programs.

Paul’s blog is always a technical cornucopia; recently, he got the inspiration to augment his technical posts with surveys of his community (brilliant, Paul! I wish I’d thought of that!). His first one is a doozy: How often do you validate your backups?

  • Almost twenty-five percent of respondents never validate their backups! Huh? Paul wisely quotes Kim, and I’d like to reinforce her statement here: you don’t have a backup until you’ve restored it.
  • Forty-one percent of respondents regularly or occasionally validate their full backups (but not differentials or logs!).
  • Twenty-eight percent of respondents regularly or occasionally validate their full backups, their differentials, and their logs.

If these statistics hold across the general user base, many of you may be working without a net. There’s obviously lots of work we can do here, and as Paul wisely points out in his article (which you really should read in its entirety), your high availability/disaster recovery plans should never rely solely on backups.

Paul’s second survey pertains to index maintenance. You can participate here.

Thanks, Paul, for the thought-provoking statistics and sage counsel.

-wp

this copyrighted material was originally posted at https://blogs.technet.com/wardpond. 

the author and his employer are pleased to provide this content for you at that site, and via rss, free of charge and without advertising.

the author welcomes and appreciates links to and citations of his work. however, if you are viewing the full text of this article at any other website, be aware that its author does not endorse and is not compensated by any advertising or access fees you may be subjected to outside the original web and rss sites.

Comments

  • Anonymous
    January 01, 2003
    The comment has been removed

  • Anonymous
    January 01, 2003
    I’m a little late to the party here, but this is pretty apropos of some of our discussions here lately.

  • Anonymous
    January 01, 2003
    The comment has been removed

  • Anonymous
    January 01, 2003
    Adam, I agree--doing a restore AND a DBCC CHECKDB of backups on a frequent, regular basis is fundamental.  This should be done at least weekly, if not daily. Dittos for diff & log backups. I advocate regular PIT exercises by all relevant personnel as well.  The time to learn how to put out a fire isn't when your home is burning down.

  • Anonymous
    March 14, 2009
    Validating your backups is great, but IMHO it's not enough.  You need to actually do a test restore from time to time (once a month would be good, once a week better ... one customer I talked to does a test restore for EVERY backup they take and while I think that's slightly overkill they can certainly sleep easy at night knowing with almost 100% certainty that their backups will restore in the case of a disaster).

  • Anonymous
    March 15, 2009
    The comment has been removed