Hi @Terry Chan
Per my research, the failover will not influence the data of the sharepoint server, which is connected to SQL server with AG listener.
From my point of view this issue is a bit weird, as I am not expert in SQL server, I would suggest you to open a ticket to get better help.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.