patternsqlModerate
Availability Group - how much data was lost after forced failover
Viewed 0 times
aftermuchlostgroupforcedfailoveravailabilityhowwasdata
Problem
Let's consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication.
Is there any way to calculate how much data was lost after forced failover?
I mean in terms of time, to be able to know "I lost 1 hour of data or 1 minute".
I have considered checking LSNs but I don't know how to translate them into datetime.
Is there any way to calculate how much data was lost after forced failover?
I mean in terms of time, to be able to know "I lost 1 hour of data or 1 minute".
I have considered checking LSNs but I don't know how to translate them into datetime.
Solution
- Go to SSMS
- Object Explorer
- Expand
Always On High Availability
- Expand
Availability Groups
- Right click your AG
- Select
Show Dashboard
In the dashboard, above the list of AG databases and their status, there is
Add/Remove Columns buttonPick
Estimated Data Loss (time) and add this column to dashboardYou will be able to see the estimated data loss time for each DB
You can check this dashboard right before you are going to do forced failover, to get the idea of how much data can be lost
Context
StackExchange Database Administrators Q#279449, answer score: 10
Revisions (0)
No revisions yet.