Tuesday, 29 September 2015 00:00

Disaster recovery in SQL Server: What your plan should look like

Rate this item
(0 votes)

Disaster recovery in SQL Server relies on three components: people, processes and technology. Your failover and failback solutions must minimize SQL Server data loss. Edgewood Solutions' Greg Robidoux guides you through decisions you'll face, including that of the appropriate DR budget to match your business goals.

There are several components to your disaster recovery plan. Enabled people, processes and technology are areas that rely upon one another. I'll discuss the level of importance all three have on a successful DR plan.

The reason for creating a DR plan is to ensure that your systems will continue to run as needed in case of any failure, whether large or small. In most cases, disaster recovery scenarios never get exercised. They act more like an insurance policy minimizing data loss and/or downtime to the smallest amount possible in the case of a failure.

Before you begin putting together a realistic DR plan, you need to think about two things: budget and need. Just about anything is possible if you have enough money, but your budget is one area that often causes you to implement a less than ideal disaster recovery solution. For the second element, need, ask yourself if your disaster recovery plan is the proper plan for meeting your business goals. In many cases, disaster recovery plans are over-engineered because of a budget surplus or the strategists do not understand the true business need. Or, the plan is under-engineered because of a lack of dollars or, again, the assessment of the real business need wasn't thorough enough.

Before you begin selecting and implementing a plan, answer these two questions:

  • If a failure occurs, how much data loss can I afford?
  • If a failure occurs, how much downtime can I afford?

Once you answer these questions, you can begin to formulate the type of solution you need as well as the costs. Oftentimes when speaking with clients the first answer is we cannot afford any data loss and we do not want any downtime. When you discuss the dollars needed in order to meet their criteria, the client's tune usually changes and so does the plan. Next, the real analysis begins.

So let's take a look at the three areas -- people, process and technology -- to see what needs to be put in place in order to have an effective DR plan within your budget.

People

The people aspect is the most important part in the beginning stages of your disaster recovery plan. The reason for this is the amount of effort that needs to go into planning, assessing, writing processes, selecting the technology and testing it. The level of people resources to monitor will be determined by the amount of money you put toward your technology component.

The amount of money you put toward technology will determine the level of people resources to monitor, failover and failback should go in the opposite direction once the initial stages have been fully researched and a process selected. From the failover and failback aspect, and depending on what method you use, your need for people resources will be either high if you use a low-tech solution or low if you employ a more high-tech solution. The primary reason for this is the level of automation and monitoring that is usually part of the solution. Unfortunately, with a high-tech solution, often you'll need more experienced people to implement it. But, in all respects, a failover situation is not something to be taken lightly and, therefore, a high level of expertise needs to exist regardless of the solution.

Keep in mind that a less automated approach means more people time is spent on the failover process and much more time is spent on the failback process. Also, depending on the complexity of the failover, such as a multi-database or multi-server failure, you may face an increased need for more resources. One person can only do so much, and if you consider that scenario when implementing your plan, it will pay off.

Process

There are several procedures and processes you should address and document in your DR plan. Writing it all down is a very time-consuming people component, but it's a very valuable one in a time of crisis. Once you document the procedures, this task is not complete. As your environment changes, you must continue to update the procedures.

Here are some items to include in your process:

  • Plan and assess your needs and budget.
  • Create an escalation list of staff members to contact at critical points of failure.
  • Create a priority list of your servers and possibly to the database level in priority rank, so you know which needs to address first in the case of a multi-component failure.
  • Establish SLAs that provide realistic guidelines with your user community if a system goes down. For instance, how much time will it take to recover based on your needs and budget? You should do that across all of your servers because if there is a widespread problem, multiple groups will probably be involved.
  • Develop roles and responsibilities regarding who is responsible for what aspect, so when a crisis does arise, there should be no arguing over who is responsible for handling any particular issue.
  • Create an audit/change log of all servers so you can go back and see what items have been updated at a server and database level.
  • Break down failover procedures based on your technology solution into the following groups:
    • One database
    • Multiple databases
    • Entire instance
    • Entire server
    • Grouped application servers -- applications that work as a team (Web servers, app servers, database servers, etc.)
    • Entire datacenter
  • Break down failback procedures based on your technology solution, which are based on the groups above.
  • Assess testing procedures: how often, what is involved and what actually constitutes a valid test.
  • Schedule a DR review process, which may be once a quarter or once a year at which time you should assess your plan to ensure it still meets your overall business needs.

Technology

After the cost of people who will plan, implement and monitor your failover solution, the technology factor is the most expensive component. Just how expensive it is depends on the solution you select for failover. There are several ways of handling failover, from the simple to complex and from inexpensive to very expensive.

The following table lists the different options that are available:

Solution Cost Complexity Failover Failback
Hardware Clustering High High Fast Fast
Software Clustering High High Fast Fast
Replication Medium Medium Medium with manual processing Slow with manual processing
Continuous Data Protection Medium Medium Medium Slow
Log Shipping Low Low Medium Slow
Backup and Restore Low Low Slow Slow
Database Mirroring Low Low Fast, but only at the database level Fast, but only at the database level

Summary

Before you can have an effective disaster recovery plan, assess your need and the budgetary dollars you can allocate toward your failover solution. Based on those needs, select the appropriate technology solution and begin to wrap your processes around the selected technology. Be sure your staff is properly trained on the technology so implementation is done correctly. They must understand the failover process and also understand how to failback to your primary servers when needed. Take the time to understand the true business need and then develop your strategy to meet the need.

Reference: http://searchsqlserver.techtarget.com/tip/Disaster-recovery-in-SQL-Server-What-your-plan-should-look-like

Last modified on Tuesday, 29 September 2015 12:11
Data Recovery Expert

Viktor S., Ph.D. (Electrical/Computer Engineering), was hired by DataRecoup, the international data recovery corporation, in 2012. Promoted to Engineering Senior Manager in 2010 and then to his current position, as C.I.O. of DataRecoup, in 2014. Responsible for the management of critical, high-priority RAID data recovery cases and the application of his expert, comprehensive knowledge in database data retrieval. He is also responsible for planning and implementing SEO/SEM and other internet-based marketing strategies. Currently, Viktor S., Ph.D., is focusing on the further development and expansion of DataRecoup’s major internet marketing campaign for their already successful proprietary software application “Data Recovery for Windows” (an application which he developed).

338 comments

  • Comment Link Adrienne Monday, 02 April 2018 03:33 posted by Adrienne

    horoscope de ce jour taureau horoscope femme capricorne du jour
    horoscope du jour gemeaux homme horoscopes connaitre son avenir horoscope
    balance homme amour horoscope du mois de novembre verseau horoscope avec ascendant du jour horoscope europe
    1 31 juillet horoscope de la femme cancer du jour horoscope lion argent du jour horoscope homme sagittaire femme poisson horoscope du
    mois lion homme horoscope mois de juin gemeaux horoscope du
    poisson horoscope taureau mois decembre horoscopes sagittaire horoscope
    poisson travail signe horoscope 17 juin horoscope mensuel
    capricorne horoscope gemeaux 3 decan 2017 horoscope jour vierge horoscope du sagitaire chance horoscope cancer horoscope vierge 3eme decan capricorne date horoscope horoscope voyance temporel lire mon horoscope du jour poissons horoscope juillet 2017 horoscope gemeau mois juin horoscope
    balance du mois de juillet horoscope sagittaire femme 2018 horoscope 22 juin 2017 vierge horoscope taureau du mois aout horoscope lion du jour journal des femme horoscope 21 juin taureau horoscope blais lion horoscope celibataire balance horoscope lion ascendant vierge femme
    horoscope taureau 21 avril horoscope d'hier capricorne horoscope dragon amour du
    jour horoscope du jours gemeaux horoscope des femmes balance tf1 replay
    horoscope horoscope du jour pour femme vierge horoscope amour vierge et taureau horoscope sante vierge du jour date horoscope poisson horoscope pour ado horoscope annee
    2017 capricorne horoscope lion 3eme decan septembre

  • Comment Link Nidia Sunday, 01 April 2018 22:05 posted by Nidia

    video dating sites review date then sex how to have great sex
    on a first date funny songs about online dating dating site for uk fans types of guys on online dating sites how to describe yourself on online dating sites having sex too soon dating free dating sites for geeks gay date apps cuckold dating sites dating older man younger woman black people dating sites italian american dating
    sites online dating etiquette when to meet free punk dating sites uk milfoholic dating site top 10 foreign dating sites best way to start a conversation with a girl online
    dating free richest dating site how to keep yourself safe online dating what are good questions to ask on dating sites 100 free millionaire
    dating site sa dating sites free best dating sites victoria bc good and bad things about online dating good catch phrases for dating sites best dating apps free uk sugar mummy dating sites in nairobi golfers dating site
    uk free uk mobile phone dating sites dating app gps android fuck date app golf dating websites
    uk moldova dating sites first questions to ask online dating best online dating sites for 50+ totally free dating websites uk free country
    boy dating sites gay dating websites in mumbai free dating sites
    for stds online dating slogans dating apps for couples hiv dating app uk online dating sites london ontario free dating sites in ireland pregnant dating sites uk top dating sites in utah sexual dating apps latest free nigeria dating site online
    dating south africa gauteng

  • Comment Link Antje Friday, 30 March 2018 01:00 posted by Antje

    taureau astrologie femme fevrier signe zodiaque astrologie jour 8 juin signe astrologique signe astrologique
    feminin masculin gemeau signe astrologique ascendant signe astrologique chinois chien de metal signe astrologique tribal lion les signes du zodiaque les plus
    riches astrologie femme verseau homme capricorne signe astrologique 29 juin signe astrologique sagittaire homme tatouage signe astrologique signification poisson serpentaire nouveau signe astrologique symbole astrologique poisson apprendre
    astrologie pdf compatibilite signe astrologique gemeaux et vierge caracteristiques signe astrologique verseau cancer signe astrologique femme date signe astrologique macron ascendant poisson astrologie ascendant signe astrologique chinois correspondant au lion compatibilite astrologique scorpion cancer quel signe astrologique le
    21 mai signe astrologique du jour verseau 12 signes zodiaque japonais signes astrologiques ascendants
    gratuits signe astrologique signification scorpion astrologie pluton en maison 11 tarot roue astrologique signification 24 aout signe astrologique theme
    astrologique en ligne gratuit signe astrologique ascendant
    homme tout sur le signe astrologique capricorne caracteristiques signe
    astrologique capricorne signe astrologique vierge homme du jour correspondance amoureuse entre signes astrologiques astrologie inca quel est le signe astrologique du
    25 novembre signification astrologie lion signification astrologie poisson signe astrologique maya chouette
    astrologie couple lion-taureau psycho astrologie signe astrologique serpent homme astrologie druidique lierre cancer signe
    astrologique du jour compatibilite signe astrologique femme lion abc de l'astrologie
    indienne collier signe astrologique signe du zodiaque balance femme

  • Comment Link Audra Thursday, 29 March 2018 06:24 posted by Audra

    voyance gratuite qui marche jeff voyance gratuit tarot voyance gratuit tirage voyance par telephone gratuite pas cher tchat
    voyance entierement gratuite horoscope belier semaine purevoyance voyance gratuite
    et serieuse en ligne salon voyance la rochelle voyance
    gratuite par carte en ligne carte de voyance site de voyance tchat gratuit voyance medium gratuite par mail voyance jeu gratuit voyance amour gratuite chat voyance
    gratuite amour par chat gratuit eso voyance forum gratuit voyance
    tel sans cb voyance var gratuite medium voyance tours
    marc de cafe voyance horoscope du jour gratuit voyance et astrologie yanis voyance horoscope fevrier
    2016 voyance sans attente 24/24 voyance idf1 planning voyance gratuite carte magie
    et voyance voyance dole jura premiere voyance gratuite par tchat
    voyance gratuite tel sans cb voyance gratuit par
    tchat immediat voyance gratuite immediate en amour ici voyance anne
    marie voyance amour gratuite en direct fabienne quaranta voyance voyance gratuite sur mon couple meilleurs site de voyance audiotel voyance gratuite en direct sans attente voyance tarot marseille
    voyance en ligne direct allo marcus voyance voyance par tel gratuit tirage iza voyance voyance gratuite en ligne amour
    voyance immediate 1 euros la minute horoscope voyance astrologie
    voyance 2017 gratuite par mail tarot voyance tchat gratuit voyance gratuite immediate par carte voyance en ligne par tchat gratuit immediate horoscope idealvoyance verseau voyance en ligne direct gratuite

  • Comment Link Shanna Wednesday, 28 March 2018 22:42 posted by Shanna

    psychics near portsmouth nh psychic lawyer what types of psychic abilities are there are scorpio moons psychic
    psychic readings credit card cheap psychic clairvoyant near me world famous psychics psychic reading in palm springs free
    online chat with psychic psychic readers in columbus ohio brian shaffer
    psychic psychic week i want to chat with a psychic psychic of orange ct psychic stars how do you know which psychic ability you
    have blue moon psychics encinitas texas psychic fairs karen peterson santa rosa psychic second sight psychic studio john edward psychic teeth psychic tv talk show psychic finding lost pets gia psychic metropolitan ave are
    you psychic test psychic paulina psychic answer
    now true canadian psychics psychic exercises with playing cards psychic intelligence pdf
    free timmothy pitzen psychic psychics in aurora colorado eldar psychic powers one free psychic reading types of psychic
    empathy lottery psychic predictions is visiting a
    psychic a sin psyshock or psychic alakazam juanita psychic townsville top psychic free psychic ability test online
    dark good against psychic i'm not crazy i'm psychic cool psychic superhero
    names psychic cost example psychic of miracles portland free online tarot card readings uk psychic woman retford
    how to strengthen psychic ability paranormal witness episodes
    dailymotion mono psychic

  • Comment Link Kate Tuesday, 27 March 2018 20:50 posted by Kate

    rachat de credit immobilier taux calculette simulation rachat credit immobilier societe de rachat
    de credit avis rachat pret immobilier taux fixe faire racheter son credit immobilier demande de rachat de credit rachat de credit comparatif taux credit immobilier rachat pret
    frais pour rachat pret immobilier racheter credit immobilier
    suite divorce banque en ligne rachat de credit rachat credit
    entre particulier rachat de pret pour sci rachat de credit si dossier de surendettement delai rachat credit immobilier rachat d'un pret
    immobilier par une autre banque cabinet de rachat de
    credit bordeaux rachat de credit immobilier pour chomeur
    rachat de credit immobilier avec taux zero rachat de credit simulation en ligne association aide rachat
    de credit rachat de credit immobilier taux variable comment trouver
    un rachat de credit regrouper ses credits a
    la consommation frais de rachat de pret immobilier taux rachat credit voiture taux
    rachat de credit sur 15 ans association rachat de credit ficp puis je renegocier un rachat de credit rachat de pret immobilier
    en cas de divorce rachat de credit immobilier en etant ficp rachat de credit et tresorerie rachat de credit immobilier avec hypotheque banque
    rachat credit rachat de credit nantes rachat de credit
    immobilier banque en ligne comparateur rachat de credit raisons refus
    rachat credit rachat credit avec taux zero conditions rachat de credit
    immobilier rachat de pret immobilier banque en ligne rachat credit immobilier banque simulation rachat credit immobilier taux fixe racheter pret immobilier par autre
    banque rachat d'un credit immobilier courtier rachat de credit
    interimaire comment calculer les frais de rachat de credit taux moyen rachat de credit conso simulation rachat credit pas
    cher organisme de rachat de credit serieux rachat credit immobilier apres
    separation

  • Comment Link Keisha Monday, 26 March 2018 17:38 posted by Keisha

    horoscope du jur votre horoscope au quotidien novembre horoscope le vrai horoscope taureau horoscope poissons aujourd
    hui horoscope celibataire du jour horoscope lion 2eme
    decan du jour horoscope femme balance aujourd'hui horoscope de hier horoscope verseau jour elle horoscope sagittaire amour horoscope taireau horoscope de l'annee vierge horoscope taureau du mois de juin 2017 horoscope
    jour sagittaire horoscope poissons du jour sante femmes horoscope
    pour homme horoscope detaille du jour horoscope vierge par decan horoscopes dates in arabic mon horoscope
    poisson horoscope celtique noyer horoscope selon date et heure de naissance perras horoscope taureau horoscope vierge homme 1er decan yahoo horoscope lion du jour balance horoscope femme
    du jour connaitre horoscope date de l horoscope
    horoscope e tessier voir mon horoscope poisson msn horoscope balance horoscope travail horoscope amoureux balance juillet 2017 horoscope amour homme m.horoscope vierge jour horoscope septembre horoscope capricorn zilnic date de naissance et
    horoscope horoscope serpent du mois cancers horoscope dates horoscope
    de mois d'aout horoscope cancer homme amour horoscope
    femme verseau du jour horoscope amour du jour vierge horoscope figaro 2017 horoscope du mois amour
    lion l internaute horoscope vierge voyance horoscope lion horoscope vogue verseau horoscope amour
    singe du jour

  • Comment Link Katrice Monday, 26 March 2018 14:32 posted by Katrice

    application rencontre gratuite windows phone rencontre sur aix
    en provence rencontres homosexuelles rencontre l amour gratuit
    rencontre virtuel pour ado site pour des rencontres application pour rencontre
    iphone rencontre 01 site de rencontre paris senior rencontre celibataire orne
    rencontre toulouse site rencontre parent solo
    site de rencontre corse rencontre 18 20 site rencontres seniors suisse
    site de rencontre connu rencontre femme a toulouse
    avis sur site de rencontre rencontre amicale entre motard rencontre haut rhin rencontres avec femmes
    sportives comment rencontrer des amis islam rencontrer une fille rencontre en direct rencontres femme
    russe site pour des rencontres rencontre soiree rencontre au puy en velay agence de
    rencontre femme russe gratuit rencontres sites avis site rencontre femmes ukraine
    rencontrer de nouveaux amis rencontres notariales clermont ferrand
    bon site de rencontre pour ado rencontre pour retraites visiter un site de rencontre sans s'inscrire blog rencontre ado rencontre cam iphone rencontre adulte rouen rencontrer l homme de sa vie rencontre
    sexe rennes montparnasse rencontre site de rencontres vraiment gratuit rencontre verdun sur garonne site rencontre russe photo rencontres sexe rennes sites rencontres russes arnaque rencontre whatsapp
    soiree rencontre celibataire lausanne rencontre en ligne premier rendez vous site rencontre sans inscription pour ado

  • Comment Link Larita Jerrel Sunday, 25 March 2018 09:59 posted by Larita Jerrel

    Hey I am doing a paper on this exact topic. What was the resource when you do your research? Is there any way I could send an email to you and you could give me some hints on where to start my research? This was very helpful!

  • Comment Link Tim Saturday, 24 March 2018 23:25 posted by Tim

    vidente particular casa cartas de videncia
    vidente para el amor gabriella vidente e medium buena vidente sin preguntas videncia
    economica y fiable como puedo ser una persona vidente
    cartas de videncia consulta tarot vidente gratis
    mhoni vidente horoscopos amor que significa
    ser una persona vidente horoscopo de hoy mhoni vidente fin de
    semana busco vidente en malaga videncia na bola de cristal gratis vidente natural medium unica cartas de tarot videncia vidente gratis por wasap
    chat videncia gratis en linea vidente real sin enganos significado de vidente y clarividente como saber si soy vidente natural
    vidente rosario dutto vidente gratis por whatsapp en argentina vidente de telecinco mas alla de la vida tarotista vidente acierta
    en todo consulta vidente 24 horas vidente natural sin cartas vidente por telefono
    mexico vidente barato y bueno rappel vidente gratis vidente telefonica buena tara videncia tarot gratis vidente seria y economica vidente brasileno predice muerte de cantante colombiano vidente famosa en mexico la mejor vidente de madrid tarot
    vidente barato vidente maria jose vidente barato
    y bueno vidente rosario montoya vidente tarotista particular luz
    maria vidente mariana tarotista vidente medium marcos vidente
    de jacarei como ser vidente natural vidente carmen palencia sobre
    venezuela el vidente mas famoso del mundo vidente bola cristal vidente bueno en valencia
    rappel vidente biografia vidente natural gratis argentina

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.