Jerry -- Why do a daily backup?

In the “I hate to complain, but…” thread that was locked – jdavis posted this:

I’m just curious here, but I wonder why you perform a daily backup when it seems that a days worth of posts are certainly not critical to the day-to-day continuance of the SDMB. I can understand a backing up to a tape drive periodically, But I just don’t know I see the point of a daily one. Maybe a weekly one? Or, maybe, let the automated backup run in the wee hours of the morning, but if it FUBARs … why not just wait and run one the next night instead of sucking limited db resources during a busy time?

And please don’t take this as bashing or complaining. I am genuinely curious.

Oh, and BTW – keep up the good work. The board has been running great for me as of late.

I do a daily backup primarily because I would get grief if I didn’t. Think of it as an essentially selfish motive designed to keep my emotional health high and my stress levels low. :wink:

The question is, is it working?

After a restart of the SDMB on Saturday afternoon the automated backups are working as usual.

Also because if he didn’t do a daily backup, he’d lose his membership in the Ancient and Honored Fraternal Order of Paranoid Sysadmins. It’s right up there in the initiation oaths, along with “I Shall Not Use Dictionary Words in My Passwords” and “I Shall Not Open or Install Unsolicited E-mail Attachments, Nor Allow Others to do the Same on my System”.

gives Chronos the secret handshake

uh-oh. You gave the secret handshake on a public message board?? jeeeeeeeeerie’s in trooooooooouble.

Don’t you know that by clicking on the ‘quote’ link, as I’ve just done, I’m privy to the deep innermost secrets of the Sysadmin world??? and I ::hears sound over shoulder:: what?!?! WHO!?!?! No, I was just kiiiiiiiiiiiiiiiding!

::crickets chirping::

Don’t forget:

  • Thou shalt not use hyphens as the first character of filenames, for they are a pain in the ass to delete.
  • Thou shalt not use Telnet, for Telnet has no soul and will barter your secrets to thieves and scoundrels. Use ssh instead.
  • Thou shalt not filter pings at the firewall, for it is commanded in some obscure RFC that you do not.
  • Right. What was your username again?

I strongly suspect that this question has been answered to everyone’s sastisfaction.

.

.

.

.

(Now, when do we move to hourly backups?)

I hope no one bitches about nightly backups again :wink:

I’m a sysadmin working with database software, and trust me, nightly automated backups are a Good Thing.

this is why we protect things?

mouthy, I’m sure you’re no longer complaning :smiley:

Oh, the irony!!

Well, even though this has been answered, it is standard procedure for all IT persons to ensure they have a nightly backup…even for the most mundane servers.

Most people can get away without a board like the SD…but as Jerry stated, people would be highly pissed if he could only back up from a month ago of posts, even a week’s loss of posts here would create havoc. Not to mention the fact that it’s standard procedure. It’s aharmless and best practice for all IT people to do along with regular testing to ensure the back up is actually working. You’d be amazed at how many crappy back ups you can get even if you think they are perfect.

If you don’t care about your own data, cool, but remember the next time your system goes down and you lost a buttload of data.

I find the hack to be lame but glad that they had their back up. Without a back up you might as well sink a server in the bottom of a lake.

Well, this is the first time in my near 2 years here that I can remember that we have reverted back to a saved db copy. It may have happened before, but I don’t remember it.

To everyone saying “This is exactly why…”, I dunno… It still seems to me that if it means taking away from daily limited db resources, I’d prefer the missing week of posts in the rare instances where we are forced to roll back.

And to all those saying “This is what you do in IT…” – my job is working with internet software and databases. So I do know a little bit about what I am talking about. I know that daily backups are a good thing, if losing data from 2 or more days back would cause severe impact to your business. I still maintain that losing a weeks worth of posts here would not kill anybody, and especially since we’ve all seen the performance problems we can sometimes have here.
Admins, as with my OP, please don’t take this as bashing – Just my 2¢ in a friendly discussion.

:rolleyes:

Please show me where I suggested we not run backups.

Judging from my reaction to the days worth of posts I lost…

a week MIGHT kill me:)

Yes, quite a … coincidence, wouldn’t you say? Rather… convenient how not only did this allow Jerry to earn accolades for his quick response, but also to defend himself against concerns that he was being overzealous. Hold on, I have to go now. There are a bunch of men in dark suits waiting outside my door. I wonder what they could want?

Jeez, calm down. She never said that you suggested that. She used her metaphor simply to show that, yes, it’s important to backup every day.

Thank you kindly Spoofely m’dear…

mouthbreather, I didn’t know you had any background in the IT business therefore I posted with the information I felt important…and Spoofe was right, it was a metaphore to give credence to my post.

I realize that the SDMB is not paramount to The Chicago Reader’s business but it is an important part of their connection to thousands of people here. Could they easily get away without a nightly back up? Sure…does it make sense? No. Why?

Because the SDMB reaches a lot of people who want to be in the know. Because, so I like to think, that the Chicago Reader cares about it’s visitors and wants to continue that relationship. A daily backup takes very little time, very little effort (knowing my backups) and is a relatively minor issue. Oh and look, when the boards were hacked it was easy for Jerry to back the boards up and get us up and running with very little loss of data. That I am sure, many here appreciate very much.

The same goes for other message boards around the net. Most message boards are free but responsible owners of message boards do what they can to ensure their site stays continuous as possible and a community that is secure. Without that, why bother having a message board?

Okee, I’m done.

< picking her shorts out of her butt now >