SSWUG July 30th Expo
Twomore day to sign up for the FREE SSWUG Expo – Maximizing SQL Server Uptime – July 30th
There are so many methods for keeping your database online. Each has it’s benefits and associated costs. What’s the best solution for you? Come reveiw the options that are provided in SQL Server 2008. When you attend the SSWUG Free expo you’ll learn about new features and important things that you’ll want to know about as you work with SQL Server 2008. We’ll also have segments on Transactional Replication for High Availability, Database Mirroring and even log shipping basics. Join us to learn about the key elements to making sure your systems are able to provide excellent uptime options for your business, clients and end-users. Sign up today.
Wash Your Servers…Who Knew?
Ok…I thought water in the server room was a bit of a unique event. Well, I guess not. Three of our SSWUG readers respond with their own personal experiences. This is a testament to good Disaster Recovery Procedures.
Mark Tells us…
While working for a global engineering corporation I received e-mails from the servers that they were all down on a Sunday night at 11pm and would not reboot. I went into the office and heard water running. As I walked down the hall I saw water seeping out from under the wall to the server room. I opened the door and saw water running down from the ceiling over the server cabinet and through it over every piece of hardware inside. It looked like a dishwasher with a glass door.
I shut off all the power and went to look for the main water shut off. I called in the team and we took the rack apart. We lost 2 switches, power supply in one switch, the power supply in the array, one server and the motherboard in another server. We took everything apart to include the array and dried everything with fans and dehumidifiers. Dell sent a tech out to replace motherboards and power supplies. We did not lose any data whatsoever. We were back up and running at 100% by 4pm on Monday afternoon.
Tom remembers…
Water in the server room? How about a flood of your city? New Orleans, 2005: Katrina hits, Army Corp of Engineers’ levee design flaws manifest themselves, flood ensues. Our company’s offices are at the top of a 13 story building and dry as a bone, but our whole city is broken. Two weeks and some new server shipments later, I’m rebuilding our databases and infrastructure from our backup tapes on new servers in our new home in Milwaukee. Turns out the flood/relocation was a blessing in disguise, business is great.
Bob writes…
Had the same problem one day. Got a call from the maintenance person one night: We got 2 inches of water in the server room. Rushed there and shut off equipment.
A water pipe in the attic over the server room froze and broke. It got two servers and a tape drive unit. All three had to be replaced.
Featured Article(s)
Tips for using SQL Server 2008 bulk copy
In this article, you can find some tips to use SQL Server 2008 bulk copy.