Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unplanned outages causing bankruptcy


Unplanned outages causing bankruptcy

Author
Message
5280_Lifestyle
5280_Lifestyle
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 325
* I wasn't sure where to ask this throughout the forum, so I decided here was best. *

For my thesis in graduate school I am choosing to do a paper and presentation on unplanned database availability and the losses it can cause, including losing money or going bankrupt. I'm trying to find information about companies that have gone bankrupt because of an unplanned database outage. I am going to present a case study on a such a company. Is there any public available information about such a company? Several Google searches have not yielded anything for me. Maybe I'm using the wrong combination of keywords.

"Nicholas"
kevaburg
kevaburg
Mr or Mrs. 500
Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)

Group: General Forum Members
Points: 586 Visits: 923
I am not sure that not being able to Access data on a database is going to be the cause of bankruptcy unless the comapny in question has made some big mistakes! There could be some Problems whereby Trends normally analysed by a Data Warehouse would be missed that could result in Business operations being hindered but even that is avoidable.

I think maybe you should consider whether just the loss of a database is the central Focus or whether or not an effective Business continuity plan is in place. Normally, when Business continuity plans are effective, the Company in question can still operate just in a very restricted manner.

The summary for your Thesis should be "a Company without a disaster recovery objective or effective Business continuity plan is the Company that will go down in the Event of catastrphic dataloss".

All you Need to do now is fill in the gaps!
5280_Lifestyle
5280_Lifestyle
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 325
Thank you for your reply! I'm definitely flexible on my thesis since, as a student with no relevant experience in such matters, for the time being I am out of my element. I appreciate your suggestion!

"Nicholas"
SQLCharger
SQLCharger
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 1401
I remember Paul Randal mentioning during a presentation recording at least one financial institution going out of business due to their systems being unavailable for several days (regulators place tight demands on availability).
If I remember correctly, that was due to mishandling corruption messages and wasting time panicking before initiating long restore sequences.

Best to contact Paul in case he can share more details (http://www.sqlskills.com/blogs/paul/)

Cheers,

JohnA

MCM: SQL2008
Tim-153783
Tim-153783
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 679
I would sent an email to Brent Ozar. I remember one of his backup presentations where he gave as examples names of companies that lost money due to the inability to restore databases.
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17635 Visits: 32268
There are actually a number of companies that have gone out of business or suffered major losses due to database issues. I wrote an article about them and published it on Simple-Talk. It has links to news articles.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3154 Visits: 3821
The organisation I work for reckons that if its systems were down for 5 consecutive days its business would be destroyed. Maybe we would not be bankrupt, but we think we would loose maybe 90% of our market share.

A job board in the UK in about 2004 had an issue where it could not update the list of jobs it had on its site for maybe 4 days. This outage caused that board to close down its UK business. If this has been publicly described you might find more details via Google.

In the late 1980s, a Frence insurance company thought it would deal with business continuity by building a 2-floor datacenter. Every bit of kit on the bottom floor was replicated with the same kit on the top floor. They forgot about floor loading and one day the top floor collapsed on to the botton floor. They did not go bankrupt but the French government made them sell the business to another organisation.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
5280_Lifestyle
5280_Lifestyle
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 325
Thank you, everyone!

"Nicholas"
kevaburg
kevaburg
Mr or Mrs. 500
Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)Mr or Mrs. 500 (586 reputation)

Group: General Forum Members
Points: 586 Visits: 923
Hi EdVassie!

This is exactly what I meant! Companies that don't have a suitable business continuity plan in the event that something goes horribly awry are the ones that will have problems when (not if) something goes wrong.

Preventionis better than the cure but then, most companies seem to work on the premise that if it doesn't have an immediately tangible financial benefit, why invest in it? Disaster recovery and business continuity are the two subjects that suffer the most from this philosophy.....
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