Between AWS RDS SQL server database (SQL Source) and the AWS RDS service for SQL Server (SQL Target), I have set up the AWS DMS sync.
The SQL source is of multi-az, after I reboot the source with failover, I noticed the DMS task failed with error message: 'Last error AlwaysOn BACUP-ed data is not available'.
I could restart the task manually without any issues, but why it failed after the failover? Or is it has to be restarted manually each time after failover?