SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Disaster in the Real World - Hurricane


Disaster in the Real World - Hurricane

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11963 Visits: 2730
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
jordanac
jordanac
SSC Veteran
SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)

Group: General Forum Members
Points: 285 Visits: 171

Thanks for the article. I found it informative as I am not used to Hurricane's in South Africa. We don't have Hurricanes's, Tornado's and earthquakes!




Andy.
BobAtDBS
BobAtDBS
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 Visits: 364

Andy: Nice article. I wish I'd had time to write a full article, our experiences were similar in some ways, different in others.

We provide a semi-public SQL Server for our customers to trade info with each other, as well as web sites and email services for them. Those servers need to keep running. I live on the north east side of Orlando, and had quite a bit of tree damage as well as minor house damage (ripped out soffits, total destruction of pool screen, tree falling across the power line to our private well - minor stuff).

Needless to say, we lost power Friday around 8:30 and didn't get it back until the following Friday night. Judging from the number of very large trees ripped out by the roots or snapped in half on our property we got a pretty good wack.

We do have a different setup in the server room though. We run all the servers off DC, all the time, including a small air conditioner. We use a couple of old telecom battery chargers to charge a bank of batteries, and a set of 48VDC to 120VAC inverters (Exeltech MX series - which I love) to keep the servers and AC running. We get about 7 hours run time on the batteries. We also use a 5KW gas generator as a backup power supply to recharge. We worked it to near death this week, but never had to shut down the servers.

Our next move will be to get a "whole house" style generator that can kick on and keep the whole office running, not just the server room.

Glad you're okay Andy, come take a tour and get a free lunch sometime.




Student of SQL and Golf, Master of Neither
Jim P.
Jim P.
SSC Eights!
SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)

Group: General Forum Members
Points: 935 Visits: 2215
Glad you all survived.

I'm in SW Ohio and the results sound sort of like the combo of a blizzard and ice-storm.

My personal rule of thumb is that you need to set yourself up for three days without outside support. My example is 3 days of food & water, and in my general case heating supplies. This is assuming your house is mostly intact. If we lose power in the winter, the fridge goes into coolers set outside.

At work, they still haven't nailed it down like that. But I'm just a peon in the DR plan.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
cppwiz
cppwiz
Old Hand
Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)Old Hand (336 reputation)

Group: General Forum Members
Points: 336 Visits: 470
It would be interesting to know your command and control structure during a disaster. With cell phones not working, were any high-level members of management not able to make decisions? When do lower-level managers make the decisions to bypass the higher levels because of lack of communication? It sounds like there was a documented plan and everyone knew the steps and contingencies, but who was making the decisions? Does IT control the business during a disaster or is the business still in control of operations?



Bob Hoffman-209065
Bob Hoffman-209065
Old Hand
Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)Old Hand (322 reputation)

Group: General Forum Members
Points: 322 Visits: 262
Last week I participated in a State wide disaster exercise in a local "disaster" drill playing a plane crash victim. Part of the drill required that we not bring cell phones (or anything else for that matter) so we would not be distracted or more probable, loose them in all that was going to happen to us. I don't live in hurricane country but do live in an earthquake and volcano prone area. Being without power in the winter (below zero temperatures) for 3 days prompted me to get a generator long ago.
My plan was to leave the cell in my vehicle and check on it, if we got a break. No break came for the entire day so no chance to check. You can guess what happened. The main server and network crashed 3 times that day. It had been running smoothly for months without problem. I am a one person IT shop. Part of my backup plan relied on another individual who had just left the company a week or so before and a replacement had yet to be determined. That persons job is to follow a set of procedures of "if this - do this" instructions. Fortunately, the automatic recovery worked each time and the day went on. Point is, disaster strikes at anytime not just in bad weather conditions (yesterday we had 80 mph winds blow through, no problems) and one must keep that disaster plan up to date. That reminds me, I'm still waiting for the buildings backup generator to be installed.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search