<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
»
The DR Test Schedule
15 posts, Page 1 of 2
1
2
»»
The DR Test Schedule
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, October 06, 2011 10:44 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
Comments posted to this topic are about the item
The DR Test Schedule
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1186911
paul.knibbs
paul.knibbs
Posted Friday, October 07, 2011 2:20 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 3:43 AM
Points: 1,257,
Visits: 4,255
The issue I have is: working for a small company, it's not so easy to lay hands on an unused server we can use to restore our data! Heck, even keeping spare mice and keyboards in stock seems to be slightly beyond the pale as far as the beancounters are concerned...
Post #1186961
Mattrick
Mattrick
Posted Friday, October 07, 2011 6:24 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 6:47 AM
Points: 581,
Visits: 694
The issue I have is: working for a small company, it's not so easy to lay hands on an unused server we can use to restore our data! Heck, even keeping spare mice and keyboards in stock seems to be slightly beyond the pale as far as the beancounters are concerned...
Although it can be difficult to procure the items necessary for a good DR system, in your situation, it is important to document the repeated attempts. If things ever blow up, and I hope they don't, you can at least tell them "I told you so."
Thanks for the article,
Matt
Post #1187033
chrisn-585491
chrisn-585491
Posted Friday, October 07, 2011 6:30 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 479,
Visits: 1,262
While I don't have the responsibility for these servers, we do have images of them, as well as regular backups, and I suspect we could recover them fairly quickly. Maybe I should ask for a test someday soon….
Why not during PASS?
If the junior DBAs at home can't pass a DR test while the "elite/MVPs" are out of town, then your DR plan is a failure.
Post #1187039
EricEyster
EricEyster
Posted Friday, October 07, 2011 6:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:30 AM
Points: 125,
Visits: 229
We have a DR drill every six months. All critical systems are tested every time. Others go through a rotation with the expectation that everything will be tested at least once every few years.
If you are short on money, consider using virtualized systems for your test. Remember, testing is not necessarily about the speed of the test system, but the ability to recover the data. In the event of a real disaster, the plan would include purchasing real hardware, but the recovery steps would be the same.
Our last test was a few days after the Irene and Lee dumped 8 inches of rain in two weeks. Our biggest concern: will the bridges be open so we can get to our test center.
Post #1187045
cathy.baker
cathy.baker
Posted Friday, October 07, 2011 6:54 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:42 AM
Points: 1,068,
Visits: 294
I work for a relatively small company that invests heavily in technology. Our critical systems have full hardware redundancy with real time replication to our DR site. We ARE in hurricane country and we do fail over our systems to our DR site at least once a year. We have other contingencies in place also.
Post #1187051
jay-h
jay-h
Posted Friday, October 07, 2011 7:09 AM
Say Hey Kid
Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 685,
Visits: 1,707
We do an offfsite DR test 2x per year.
In addition we are in a building with diesel generators and sufficient fuel to run for several weeks.
...
-- FORTRAN manual for Xerox Computers --
Post #1187061
Ninja's_RGR'us
Ninja's_RGR'us
Posted Friday, October 07, 2011 7:17 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 6:43 PM
Points: 21,357,
Visits: 9,536
jay holovacs (10/7/2011)
We do an offfsite DR test 2x per year.
In addition we are in a building with diesel generators and sufficient fuel to run for several weeks.
When you tried to run 24 / 7 on those generators, how many weeks did you last?
Do you check regularly that noone is "sniffing off" some of that fuel?
What happens if the fuel gets contaminated (I'd check here that everything is up to regulations, and highly unlikeky to be destroyed in the normal huge storms in your area).
Post #1187068
jay-h
jay-h
Posted Friday, October 07, 2011 7:25 AM
Say Hey Kid
Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 685,
Visits: 1,707
Ninja's_RGR'us (10/7/2011)
jay holovacs (10/7/2011)
We do an offfsite DR test 2x per year.
In addition we are in a building with diesel generators and sufficient fuel to run for several weeks.
When you tried to run 24 / 7 on those generators, how many weeks did you last?
Do you check regularly that noone is "sniffing off" some of that fuel?
What happens if the fuel gets contaminated (I'd check here that everything is up to regulations, and highly unlikeky to be destroyed in the normal huge storms in your area).
Good questions. We are located in a manufacturing plant and the generators are maintained by our plant engineers. They are regularly tested (and certified for enviro regs), actually kind of an overkill in capacity for just a data center, but it is a nice luxury. Two Caterpillar turbocharged 6 cylinder engines and one 12 cylinder Cat. (One of our company's lines is electric distribution switch gear so we have a nice setup).
They share the same fuel supply as can be used in heating units (we also have natural gas) so the fuel level is rotated. It's one big killer size steel tank at the back of the plant.
...
-- FORTRAN manual for Xerox Computers --
Post #1187080
Ninja's_RGR'us
Ninja's_RGR'us
Posted Friday, October 07, 2011 7:32 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 6:43 PM
Points: 21,357,
Visits: 9,536
Ya my whole point is that untill and unless you try it, you just have no idea how much fuel "time" you really have.
I'd be assuming here that other system would draw power from that generator and that more might actually join in in a REAL dr situation.
It may sound like overkill but I'd ask to try and run the whole plant on a saturday strictly off those generators. Measure the fuel before & after and see if you forgot to plug anything that actually needs to run.
Also see how fast you can get delivery from the fuel company if you run out. Depending on the disaster, they might not be able to help quickly (if at all).
We had an icesotorm in Quebec a couple years ago and it took anywhere from 1 to 6 weeks to get electricity back (yes in winter in -20 conditions).
Fuel stations and convinience stores were all raided after day 1, not withstanding all the stores that had usefull equipement to sell.
Post #1187089
« Prev Topic
|
Next Topic »
15 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.
