Home » Admin »sqlserverpedia-syndication »SSC »Tech and Learning » Currently Reading:

Twitter Talk Theatre, Episode 1: “RAID is good enough!”

But We've Never Had a Disaster Before!

But We’ve Never Had a Disaster Before!

This week, some of my Twitter followers were kind enough to chime in on a topic near and dear to my heart: the proper caretaking of SQL Server. Here is some of what we said.

Me: Common scenario: A company has databases, but no “assigned” DBA. So, broken backups, no maintenance, no disaster recovery. Guys? I can help.

@wnylibrarian But they’re backing up the VM that the databases are on. That’s enough, right? ;-)

Me: If you don’t mind giant logs, no DR…

Me: Pop quiz, my people: Tell me WHY RAID isn’t enough. (Hold off on answering, if you’ve written a book about this…)

‏@SQLBob because a disaster is way more than just a drive failing!

Me: DING DING DING DING! Winner!! Other answers accepted…

@williamweber DB corruption, I choose you!

Me: Well done, have a cookie.

@AirborneGeek My usual short/sweet answer is: Data redundancy is not data backup.

@wnylibrarian Because its not a true DB backup. There are consistency issues.

@adamhill Time to rebuild failed drives and soft failures during the rebuild that cause rebuilds of the rebuilds on very large HDDs?

Me: Well done [@AirborneGeek]. You also get a cookie. Also @wnylibrarian & @adamhill

‏@crummel4 b/c sometimes a second disk fails before ops can swap the first. Like two failures w/in 5 minutes.

Me: Right. Or, you know, power fails. Or the building catches fire, or is swept away in a natural disaster. Whatevs.

Me: Actual quote from DBA, during a DR discussion years ago: “But, we’ve never had a disaster *before*!”

@DaveSchutz You can have multiple drives fail, network errors causing DB corruption, many other problems that muck up your DB.

@GFritchey It isn’t a book, but here’s why backups are important: https://t.co/IIhMqc6peW

Thank you, Grant, and thank you, everyone. You’ve illustrated the point perfectly.

-Jen McCown
http://www.MidnightDBA.com/Jen

Sad database? I can help. Email me, or find out more about my consulting at www.MidnightSQL.com!

Currently there are "3 comments" on this Article:

  1. Steven Howes says:

    My favourite was always “you can have good backups, or a good resume. Choose one.”

  2. [...] Twitter Talk Theatre, Episode 1: “RAID is good enough!” - Twitter can be a fantastic source of insight and knowledge if you use it right. SQL community knowledge pooling in action, courtesy of your host Jen McCown (Blog|Twitter). [...]

  3. vps says:

    I really like this site. You write about very interesting things. Thanks for all your tips and information.

Comment on this Article:







MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

May 10: SQL Saturday Houston
August 2: SQL Saturday Baton Rouge (planned)
August 22-23: SQL Saturday Oklahoma City Precon!

Blog Posts by Category

DBAs@Midnight

How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!

DBARoadmap.com

The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/