How do you know all the HADR scenarios, errors and steps to resolve it

Chaitanya Kiran 101 Reputation points
2021-05-14T06:52:10.777+00:00

How do you know all the HADR scenarios, errors and steps to resolve it. Did you guys learn it from any book ? Could you please let me know the book as I am interested.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,250 questions
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2021-05-14T09:22:22.657+00:00

    Hi @Chaitanya Kiran ,

    It is hard to find a book that include all SQL server HADR issues.

    Suggest you read below MS documents that include frequently asked questions about SQL HA.

    Troubleshoot SQL Server AlwaysOn issues
    Troubleshooting automatic failover problems in SQL Server AlwaysOn environments

    For understanding SQL HA\DR, suggest you read the blog SQL Server HADR overview.

    Hope this could help you. BTW, if you want to get more blogs or documents about this, suggest you using Google, type the key point SQL server HADR , the result will show you many blogs and documents related to this.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Alex Bykovskyi 1,351 Reputation points
    2021-05-15T05:57:21.65+00:00

    Hey,

    There are useful guides available, which could help. As an example:
    https://blog.sqlservercitation.com/2017/01/24/how-to-troubleshoot-always-on-synchronization-issue/

    In addition the following guide should help with configuration:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-sql-server-hadr-using-availability-groups-and-failover-cluster-instance/

    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