SQL Server Performance Forum – Threads Archive

Disaster Recover Plan

Can i download from somewhere
disadter recovery plan template for SQL Server 2000?

This article <a target="_blank" href=http://www.devx.com/enterprise/articles/drecovery/default.asp]>http://www.devx.com/enterprise/articles/drecovery/default.asp]</a> from DEVX is one of best I have seen so-far (ofcourse we do have our own plan in place <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ />) Also refer to this link <a target="_blank" href=http://www.sql-server-performance.com/greg_robidoux_interview.asp]>http://www.sql-server-performance.com/greg_robidoux_interview.asp]</a> in this website. _________ Satya SKJ Moderator SQL-Server-Performance.Com

The issue of disaster recover plans has come up before. Would anyone be interested in submitting their company’s disaster recover plans so that others can review them. I understand that some of them might contain proprietary information, but this specific information could be removed from the plans before they are published here. I think doing so would be very useful for other people. One option would be to publish them in the forum, another option would for me to publish them in the form of an article series on the website. I would also be willing to take current plans and rewrite them to make them generic (removing specific company information). What do you think about this, and who would be willing to contribute? —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

Brad, thats nice idea to share the knowledge. I am ready to send the details, any format or formal document to do so. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Hi Brad, By studying some of the articles mentioned on this site as well looking in some other DR related site i have prepared a Disaster recovery system for our office, i would like to share the same with u & other users. Would like to send the same to you, not sure whether it is a perfect DR plan but according to the recomendations & articles have done best as per my ability. Do point in any recomendations or suggestions relating to it. Plzz tell me how should i mail the DR plan. Thanks Bhushan

If somebody contribute DRP already where i can find it?

Have you referred to the above link about http://www.sql-server-performance.com/greg_robidoux_interview.asp]. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Yes and i found this article very usefull. I am in a proccess of writing DRP now so i thought it would be very nice to see how other DBA create that document. My solution. 1. Scenario1<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />escription Steps to recover with specifing exact path to all doc. ScenarioN<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />escription… Scenario(as many as i can create)…. 2. I also plan to include document which will contain all databases, jobs with brif description .Maybe i will prepare Excel doc for that. 3.Phone list of peple / services on call 4.Phone list of people to be notified

You’re on right track in creating DR document, proceed with your plan. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

I found this site and feel that have to share
This is DRP! http://www.informit.com/isapi/produ…-475A-9CB6-1FCFB41302EF}/content/articlex.asp

You can send your plans in any format, although Word will probably work best. Send them to me at [email protected] —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

Hi Brad, I have send my DR Plan at the above mentioned email address, kindly check it at your end. Thanks Bhushan

I’ll gather all of the DR plans and then publish them in the form of an article. Thanks all who contribute. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

I found one DRP http://databases.about.com/gi/dynam…qlserver.com/backup/disasterrecovery65_p1.asp

Just an update to the link. It sees the link is not working.
The link ishttp://www.mssqlserver.com/backup/disasterrecovery65_p1.asp
The plan is in word format athttp://www.mssqlserver.com/backup/disasterrecovery65.doc Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

I have received two DRPs, and will be publishing them as soon as I find the time. Thanks for those who have contributed. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

When disaster strikes, how quickly will you be able to determine its affect on your business? Before something happens, download this form and use it to determine your organization’s ability to keep the business running in an emergency. Disaster recovery business impact analysis form
http://techrepublic.com.com/5129-6337-10223083.html Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Hi, There are several DR architectures as business market. For example, 1st Financial bank and insurance company must construct very critical platform like SRDF(Symmetrix Remote Data Facility) of EMC and Cisco. If you can allow very much downtime like 1 days over, you just can set up w/ Vaulting solutions. I think, it’s the solution for you to make the best DRP by taking on-site seminar w/ solution company "VERITAS", "EMC", "CISCO" etc…Doing so, you can get the optimized your Disaster Recovery Plan. Thanks. Ted Kim
Sr. System Engineer
CJ Systems

Sorry about taking so long, but I have finally posted on the website two SQL Server disaster recovery plans so kindly provided by two of our forum members. I have made them anonymous for obvious reasons. If you would like to contribute your disaster recovery plan for others to learn from, please contact me directly. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

]]>