Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Disaster Recovery - An Afterthought? Expand / Collapse
Author
Message
Posted Saturday, June 27, 2009 1:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:16 PM
Points: 31,018, Visits: 15,456
Comments posted to this topic are about the item Disaster Recovery - An Afterthought?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #743162
Posted Sunday, June 28, 2009 12:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:39 PM
Points: 183, Visits: 359
When it comes to DR and internet focused technology staff, I’ve seen few who really understand the importance of recovery. Just take a look at the use of MySQL - it has a terrible recovery model, but there are countless many who swear by it - It’s not SQL Server. I find that many people do not want to spend time worrying about something that might never be needed. Until it is too late - Same with any other kind of backups.

Case in point - just look at how few people have even bothered to comment!


The more you are prepared, the less you need it.
Post #743299
Posted Monday, June 29, 2009 12:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 6,723, Visits: 8,462
You only know what your insurence pollicy is worth, the first time you need to call for its couverage !

In case of sqlserver, you can challange your DRP before you actually have a live issue, so you better test it !

Maybe Steve can query the forum db(s), for the test "I've lost my db" , "My server crashed and I have no backup", "deleted mdb file", "ldf file drive lost", ...
Just to give an impression of how frequent this kind of stuff occurs "publically".


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #743377
Posted Monday, June 29, 2009 4:51 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Disaster recovery? What's that?

I'm almost ready to stop asking if people have backups when they post corruption questions. It's a waste of time.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #743486
Posted Monday, June 29, 2009 6:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
I've taken over DBA duties twice now, at two different companies. Both had backup plans in place. Neither had ever tested them. Both were backing up to the same media as the data and log files. Neither was cleaning up old backups correctly and were having drive space issues.

And backups are just the start of disaster recovery. NONE of the rest had been done.

I think "disaster recovery" needs to be renamed to "disaster prevention". It's not a disaster if you can easily recover from it. In that case, it's merely an emergency.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #743582
Posted Monday, June 29, 2009 7:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 PM
Points: 1,889, Visits: 2,036
No offense to anyone intended, but to me the title of this editorial was misleading. Disaster Recovery is a concept bigger than just having proper backup/recovery processes in place to handle mistakes or simple server or cluster failures. Disaster Recovery is more about the second level of "backups" if you will. The premise of Disaster Recovery typically is that an entire data center is non-functional for whatever reason, and you need to have alternate available resources to be able to take on the data storage and processing load that the regular production servers were handling.

While I agree that you typically need to have your first level of failover or recovery processes in place to handle the basics before you even think about Disaster Recovery, the fact that the editorial doesn't even mention the possibility of the entire data center being unavailable shows how much of an afterthought Disaster Recovery has become, and how its meaning is watered down. While it may not be as important for every company to worry about having redundancy in multiple physical locations, there are many companies that should be concerned about this who aren't.
Post #743605
Posted Monday, June 29, 2009 7:59 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Chris Harshman (6/29/2009)
No offense to anyone intended, but to me the title of this editorial was misleading. Disaster Recovery is a concept bigger than just having proper backup/recovery processes in place to handle mistakes or simple server or cluster failures.


True, but if people don't even have backups, what's the chance that they have anything?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #743634
Posted Monday, June 29, 2009 12:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:57 PM
Points: 7,064, Visits: 15,270
GilaMonster (6/29/2009)
Chris Harshman (6/29/2009)
No offense to anyone intended, but to me the title of this editorial was misleading. Disaster Recovery is a concept bigger than just having proper backup/recovery processes in place to handle mistakes or simple server or cluster failures.


True, but if people don't even have backups, what's the chance that they have anything?


Absolutely true. That said - when the backups are stored on top of the server they back up and you have a server overheat.... (Inject your own disaster scenario here)

Once you get past the first AND second doors, you really are talking about a reasonably small amount of groups. Pretty scary actually.


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #743892
Posted Monday, June 29, 2009 11:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:56 AM
Points: 6,723, Visits: 8,462
Oh indeed....
One of our devs was astonished his server didn't work after a 380V overload (it should be 220V and due to an electrical mishap the cerquit got an overload boost).
You can immaging what happened to that server.

He tought his RAID1 disks were enough for failsafe mechanisme

It took a couple of days and $$ to get that system to its new ruining state.

If he would have followed our advise, his downtime would have been maximum a couple of hours.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #744176
Posted Tuesday, June 30, 2009 5:47 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:16 PM
Points: 31,018, Visits: 15,456
A disaster encompasses many things, not just losing a data center. A disaster can be someone deleting a single table (or even row), coffee spilled on a server, all the way to a major disaster like a hurricane that removes your data center.

I've seen plenty of people focus on the big disasters and then not be able to handle small ones. It's all levels of disaster recovery that need to be handled, but IMHO, the small ones, the deletes, the corruptions, are where you have to start. They are way, way more likely than your entire data center being down.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #744320
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse