<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Disaster Recovery - An Afterthought?
16 posts, Page 1 of 2
1
2
»»
Disaster Recovery - An Afterthought?
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, June 27, 2009 1:28 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 11:09 AM
Points: 31,416,
Visits: 13,730
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
Andrew Peterson-472853
Andrew Peterson-472853
Posted Sunday, June 28, 2009 12:19 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, January 16, 2013 7:40 AM
Points: 136,
Visits: 259
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
ALZDBA
ALZDBA
Posted Monday, June 29, 2009 12:18 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 6,861,
Visits: 8,048
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
Jul 13
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
GilaMonster
GilaMonster
Posted Monday, June 29, 2009 4:51 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686,
Visits: 29,943
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
GSquared
GSquared
Posted Monday, June 29, 2009 6:49 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439,
Visits: 9,569
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
Chris Harshman
Chris Harshman
Posted Monday, June 29, 2009 7:30 AM
SSCommitted
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:19 AM
Points: 1,562,
Visits: 1,716
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
GilaMonster
GilaMonster
Posted Monday, June 29, 2009 7:59 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686,
Visits: 29,943
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
Matt Miller (#4)
Matt Miller (#4)
Posted Monday, June 29, 2009 12:49 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:49 PM
Points: 6,998,
Visits: 13,946
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
ALZDBA
ALZDBA
Posted Monday, June 29, 2009 11:33 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 6,861,
Visits: 8,048
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
Jul 13
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, June 30, 2009 5:47 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 11:09 AM
Points: 31,416,
Visits: 13,730
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 »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
