I have the following questions about SQL Server Always On:
- How does SQL Server copy data changes from the primary node to the secondary nodes?
Through log shipping (backup & restore transaction log)?
Or bitwise copy (copy all the changes in bit level)?
It seemed Microsoft hasn't tell us.
Many people ask me it but I can't give them a clear answer.
2. If I have 3 nodes: 1 primary node C01 and 2 secondary nodes: C02, C03, can I tell Always On : if C01 down, please fail over to C02 unless C02 is not available, can I?
I can't find any parameter in Always On can do that.