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


Disaster Recovery Week


Disaster Recovery Week

Author
Message
crazy4sql
crazy4sql
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4213 Visits: 4514
dont you think DR plan is also part of business continuity? Which business will plan DR without considering business continuity :-D

----------
Ashish
Rudy Panigas
Rudy Panigas
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2410 Visits: 1322
DR + BCP = Success :-)



john.w.walker
john.w.walker
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 45
All businesses should plan for DR and BC, but the weekly topic is DR and this is all about BC. I would thing SQL Server Central would know the difference. Even Steve's original story to start it is BC.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146665 Visits: 19432
Which original story? Losing power in a data center? That's a DR, technology related issue.

Companies trying to be sure their data centers are running after hurricane Sandy, that's DR. There's a BC component to that, but the piece we are talking about here, with people working in technology, is the technology end of a disaster, which is usually known as DR.

If you want to be pedantic about it and dig into what is BC and what is DR, that's fine, but I think that's a bit of a waste of time.

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
john.w.walker
john.w.walker
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 45
Right Sandy is DR. None of your stories are, no matter what scewy name you give someone that expects to read about DR when advertised Steve.
Rudy Panigas
Rudy Panigas
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2410 Visits: 1322
So anyone else have experienced an actual DR? I would like to here more from them. What did they learn? That doesn't mean just like a Sandy situation but also like a server(s) have died for some reason, prolong power outage, A/C down, etc.

I've help out with DR in many situations that are not weather related. Even worked on a DR for a company that their building was damage from an earthquake. It didn't fall but no one was allowed in for months. That to me is also a DR situation.

Rudy



john.w.walker
john.w.walker
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 45
My point exactly Rudy, I was excited to hear about DR, but instead it is BC and all of us can tell about servers and storage blowing up.
Rudy Panigas
Rudy Panigas
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2410 Visits: 1322
Well, like I mentioned before it appears that lots of people for get about DR situations where you need to rebuild basically everything from scratch. I would be interesting to see a poll on how many people have bare metal build documentation and if it's up to date.

Rudy



ashepard
ashepard
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 18
(grins a sly grin) By the way - there is one more part called "the application" I never restore them myself but I hear tell that a database with out web server, app server and such is not useful.
I disagree (smiles) I use the database all day long without every having to log in and use the app. :-D

Seriously, (sigh) there is more to the system than just the database.
1) Web and app servers
2) AD servers for authentication. SA works fine for me but .....
3) Tape/Disk backup servers to backup my backups.
4) Routers, and other hardware.
5) Bathroom and vending machines. I've been surprised at how many DR discussions about DR sites never, *never* discuss security, bathrooms, vending machines or where we will live/stay. Some how everyone will go to the DR site and laundry, living, etc will just take care of itself. w00t
Rudy Panigas
Rudy Panigas
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2410 Visits: 1322
I agree but the app systems (web, routers, networking, apps, bathrooms) are not "really" the job of the DBA. If you are responsible for those things then you need to document that too.

Most companies have network teams, development teams, etc. that would manage those parts of the disaster. If your a DBA with those responibilities then I hope your well paid.

Rudy



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