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


Disaster Recovery - An Afterthought?


Disaster Recovery - An Afterthought?

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36062 Visits: 18736
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
My Blog: www.voiceofthedba.com
Andrew..Peterson
Andrew..Peterson
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 Visits: 682
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.
ALZDBA
ALZDBA
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6972 Visits: 8839
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 w00t

- 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" :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47191 Visits: 44358
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, MVP, M.Sc (Comp Sci)
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


GSquared
GSquared
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14375 Visits: 9729
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
Chris Harshman
Chris Harshman
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2667 Visits: 3260
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.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47191 Visits: 44358
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, MVP, M.Sc (Comp Sci)
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


Matt Miller (#4)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7639 Visits: 18062
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?
ALZDBA
ALZDBA
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6972 Visits: 8839
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 w00tw00tHehe

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 w00t

- 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" :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36062 Visits: 18736
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
My Blog: www.voiceofthedba.com
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