Query on SQL Server HA and DR

Question

Hi All,

we have configured sql server always on failover cluster (two nodes) and both DB nodes are hosted on same DC. Application is using Listener IP to connect DB.

HA: Avoid service impact during planned or unplanned events

DR: Business continuity

As per my understanding, the above solution is HA not both HA-DR. Please correct me If I am wrong.

Can we consider daily backups (full and log) as a both HA-DR solution?

Answer 1

You can use AlwaysOn for both HA and DR.

More at https://learn.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver16

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 2

I would say that the AG is both HA and DR, particularly if you have synchronous commit.

You still need to do backups, full and log, but that alone may not suffice as DR, depending your RTO. (That is, how soon you need to be up after a disaster.)

Answer 3

Hi @PraveenKumar

we have configured sql server always on failover cluster

As experts answered above, AlwaysOn is a powerful technology that combines HA & DR.

Can we consider daily backups (full and log) as a both HA-DR solution?

Daily backups are used to recover data after a failure, which means a lot for disaster recovery. However, HA is not achievable.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 4

Hey,

As noted, there is Always ON which can be used to configure both HA and DR. Might be helpful: https://www.starwindsoftware.com/blog/high-availability-and-disaster-recovery-with-sql-alwayson-fci

As for backups, daily backup serve for different thing. It allows you to restore you DBs to a certain point of time, while HA and DR allows you to avoid or minimize downtime. https://www.linkedin.com/pulse/high-availability-vs-disaster-recovery-whats-why-matters-nasser/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.