-
Clarification about SQL failover and data loss
updated 4 days, 19 hours ago
1 Member
·
2
Posts
-
Hi!
In review mode set 1 – question 30 the answer says that “Azure SQL Managed Instance offers automatic failover with zero data loss” but “Azure SQL Database Standard does not provide automatic failover with zero data loss”. I’m confused as to where to find this in the documentation. Does this reference a planned synchronous failover? Because from what I can tell that’s the only way to guarantee “no data loss”. So isn’t that true for both/all tiers then?
/JR
-
In another similar question (set 3, question 11), the answer states that SQL MI GP does not guarantee zero data loss during failover, but this MS article clearly says it does: https://learn.microsoft.com/en-us/azure/reliability/reliability-sql-managed-instance?pivots=general-purpose
Log in to reply.