Query on SQL Server HA and DR

PraveenKumar 276 Reputation points
2024-06-06T14:04:31.94+00:00

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?

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,547 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,114 questions
0 comments No comments
{count} votes

Accepted answer
  1. Marcin Policht 16,335 Reputation points MVP
    2024-06-06T15:13:26.85+00:00

    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

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 104.1K Reputation points MVP
    2024-06-06T21:11:27.6433333+00:00

    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.)

    0 comments No comments

  2. LiHongMSFT-4306 24,926 Reputation points
    2024-06-07T01:44:14.76+00:00

    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".

    0 comments No comments

  3. Alex Bykovskyi 1,836 Reputation points
    2024-06-07T11:27:25.0166667+00:00

    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.

    0 comments No comments