From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Troubleshoot an HA or DR solution

Troubleshoot an HA or DR solution

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Troubleshoot an HA or DR solution

“

- Welcome back, this is lesson 15.8, troubleshoot a high availability and disaster recovery solution. Troubleshooting, let's talk troubleshooting, beginning with Always On Availability groups. There are a few tools you can use to troubleshoot an availability group starting with the SQL Server error logs. These logs capture and log state transition events for availability groups, replicas and databases, statuses of other always on components and always on errors. So the best place to look first is the SQL Server Error Logs. The Availability Group dashboard provides a quick view of the health of your availability group in a nice dashboard. And in the previous video I mentioned clicking the add remove columns and adding some of the columns there that will help troubleshoot some of the issues like your RPO and RTO issues to see how things are performing there. The cluster log isn't a availability group specific, but it does generate a log related to the failover cluster. There are some…

Contents