SQL Server Performance

Disaster Recover Plan

Discussion in 'General DBA Questions' started by NewDBA, Jul 21, 2003.

  1. NewDBA New Member

    Can i download from somewhere
    disadter recovery plan template for SQL Server 2000?
  2. satya Moderator

    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=';-)' />)<br /><br />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.<br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br />
  3. bradmcgehee New Member

    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
  4. satya Moderator

    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
  5. itbhushan New Member

    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
  6. NewDBA New Member

    If somebody contribute DRP already where i can find it?
  7. satya Moderator

  8. NewDBA New Member

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

    You're on right track in creating DR document, proceed with your plan.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  10. NewDBA New Member

  11. bradmcgehee New Member

    You can send your plans in any format, although Word will probably work best.

    Send them to me at webmaster@sql-server-performance.com.



    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  12. itbhushan New Member

    Hi Brad,

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

    Thanks

    Bhushan
  13. bradmcgehee New Member

    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
  14. NewDBA New Member

  15. gaurav_bindlish New Member

  16. bradmcgehee New Member

    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
  17. gaurav_bindlish New Member

    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
  18. dktiger New Member

    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
  19. bradmcgehee New Member

    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

Share This Page