Disaster Recovery

On this page, I am going to target some of the different options that are used in a SQL Server Disaster Recovery Plan (DRP).  Your 'DRP' is the process that you will use to recover from a failure. I have tried to provide a very general outline for the more commonly used options, that you can then use within your own disaster recovery solutions.  

SQL Server Disaster Recovery options: 

    
        The most complete method, in my opinion, as it provides recovery of the entire server.
        Because this is designed at the server level, recovery can be achieved with very
        little downtime. 

     Database Mirroring      
         This provides recovery only at the database level, and can only be used on databases 
         with FULL recovery model.

     Replication                  
       This option is a bit higher-maintenance, in my opinion, but Transactional replication
        replicates the data from one server, the publisher, to another server, the 
        subscriber, with less latency than log shipping.

     Log Shipping                
         Automated transfer of log backups from primary to secondary, only provides recovery 
         at the database level.

     Backup/Restore           
         The most basic technique, but the backup is the most important component within a 
         disaster recovery solution.  


5 comments:

  1. Very useful post. Thanks for providing complete information on disaster recovery SQL server.

    ReplyDelete
  2. Completely my pleasure! Please let me know if you need anything else.

    ReplyDelete
  3. This blog is very nice and informative!
    Keep update...
    Thanks for sharing.

    ReplyDelete
  4. All main disaster recovery features listed, enjoyed reading!

    ReplyDelete
  5. Thank you, Timothy! I believe I may need to update it a bit, but I am glad to have helped.

    ReplyDelete