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


DR Prep


DR Prep

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)

Group: Administrators
Points: 144254 Visits: 19424
Comments posted to this topic are about the item DR Prep

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 Kernodle
Andrew Kernodle
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1324 Visits: 8135
I'd say that, this year, my main DR plans would be teaching the next-most-technically-competent person here (who isn't a programmer, unfortunately) about basic DR principles. I might not be available at all times (though the company certainly expects me to be!), so someone else should definitely be aware of what needs to be done in an emergency. Already drafting some tutorials on how our DR process should go, and we'll take things from there.

Thankfully, my own DR prep routine seems to be fairly good; daily DBCC, backup, and restore, done in the off-hours. The practice has paid off, too, as just this week we had an incident where all of the data in a table was vaporized by accident. Thanks to practicing a restore routine every day, though, I was able to get a copy of the database restored and all of the data replaced in 15 minutes; practice is definitely key in such a situation!

- :-D
Rod
Rod
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: 7008 Visits: 2175
Very timely discussion, Steve. Last year, for the first time that I'm aware of, we wrote up some DR plans, with respect to our database. (It's appalling to think we hadn't done this before.) I appreciate your bringing up the fact that we should do a drill on this, at least once a year. I think I'll bring this up at our next IT meeting, next week.

Kindest Regards,Rod
Connect with me on LinkedIn.
TravisDBA
TravisDBA
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3302 Visits: 3069
Backups are only half the story. The real important part of DR is how fast can you get the databases back to point in time and operational once you have all the backups covered? Your user could care less about your backups. They are however, concerned about your restore process though because that directly affects their downtime. So, automate your restore process by building a job that nightly scripts out and saves all your users database restores (FULL,DIFF,T-Log) right up to point in time including the stop at clause, so that all you have to do is bring the script up in in the Query Analyzer in case of emergency and plug in the stop at time and you are ready to go. This front work will definitely cut your down time drastically and you will sleep much better knowing that those scripts are there everyday. I have this stored procedure/job on every production SQL Server we have. Always remember this, no one appreciates what a DBA does until they cant get to their data!!!!!!!:-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Dizzy Desi
Dizzy Desi
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 Visits: 687
I'm hoping that my organization will get beyond just talking about it and do something about it. We go through several hours of meetings each year to discuss the plans, issues, etc. But we have yet to see any action come from it, including simple things like moving a couple of servers to the DR location so we have some available.... so far it's looking like it's simply an exercise so that someone can check a box saying they've done it.

And wouldn't it be nice to actually have a DR exercise to test what we have? w00t
dduensing
dduensing
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 162
It is interesting to see how interconnected all of the various systems are today. We are discovering that systems considered 2nd, 3rd, even 4th priority have hooks that need to be available in the event. Duplicating/replicating databases, even AV infrastructure suddenly shows up, because other processes require that to be in place. File structures to deliver "critical" functions have to be consistent across the enterprise (DFS, replication, something!) Testing itself can be difficult, can you test around naming services, routing requirements, even MPLS availablity! Individual system testing is required, but the whole pie can be difficult to see!



SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: General Forum Members
Points: 65655 Visits: 18570
I will be scheduling additional testing. I also have a few more checks that I will be implementing.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

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