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.
little downtime.
This provides recovery only at the database
level, and can only be used on databases
with FULL recovery model.
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.
replicates the data from one server, the publisher, to another server, the
subscriber, with less latency than log shipping.
Automated transfer of log backups from primary to
secondary, only provides recovery
at the database level.
The most basic technique, but the backup is the most important component within a
disaster recovery solution.
Very useful post. Thanks for providing complete information on disaster recovery SQL server.
ReplyDeleteCompletely my pleasure! Please let me know if you need anything else.
ReplyDeleteThis blog is very nice and informative!
ReplyDeleteKeep update...
Thanks for sharing.
All main disaster recovery features listed, enjoyed reading!
ReplyDeleteThank you, Timothy! I believe I may need to update it a bit, but I am glad to have helped.
ReplyDelete