February 3, 2019 at 11:02 pm
What is the difference between high availability and disaster recovery ?
Also proxy and credentials
February 4, 2019 at 12:21 am
what have you found so far on google/documentation and what specific differences/relations between each pair have you questions about?
February 4, 2019 at 3:42 am
ramyours2003 - Sunday, February 3, 2019 11:02 PMWhat is the difference between high availability and disaster recovery ?Also proxy and credentials
From SSC :
https://www.sqlservercentral.com/Forums/1408736/Disaster-Recovery-DR-Vs-High-Availability-HA
http://www.sqlservercentral.com/blogs/stratesql/2013/07/10/security-questions-logins-credentials-and-proxies/
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 4, 2019 at 5:10 am
I found one helpful article that discusses high availability and disaster recovery. This may help you out:
http://mstechtalk.com/sql-server-high-availability-disaster-recovery-options/
February 6, 2019 at 11:41 am
ramyours2003 - Sunday, February 3, 2019 11:02 PMAlso proxy and credentials
Check out this article https://social.technet.microsoft.com/wiki/contents/articles/36797.sql-credentials-and-proxy-for-agent-job.aspx
February 7, 2019 at 9:33 am
Good links, but short answers:
HA is about ensuring availability of a resource, this often uses multiple nodes to ensure we can access a resource if one node fails.
DR is about recovering systems when disaster strikes. This is a part of HA. IF node 1 fails, node 2 takes over, but we sitll need to recover node 1. If we have corruption or data mistakes, we have to fix this. HA doesn't often help with those.
Proxy - A service that acts on behalf of another. This could me a computer process or a human.
Credentials - way of authenticating someone/something. user/password, sSh key, etc.
February 7, 2019 at 12:22 pm
High Availability would ensure there is minimal downtime if for whatever reason (planned or unplanned) the primary server or resource is unavailable.
Disaster Recovery would ensure there is a plan on how to deal with the situation that an entire system (systems or possibly even an entire datacenter) is down or unavailable. E.G. if you have 2 servers setup for high availability and both are unavailable what would you do? Many companies have an offsite plan for how to recover from such a situation to handle the entire datacenter being unavailable.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply