Hi @udhayan d ,
Please refer to official document: Role of the Witness in Automatic Failover
I expect only the auto failover cannot happen during the the outage on witness server and no impact to data sync between my principal and mirror.
In mirroring, a witness server is not required. With a witness server, the principal and mirror databases talk to the witness server in addition to maintaining a session with their partners. There is no replica of the database on the witness server, it just acts as a neutral arbitration to establish a session with the principal/mirror server, determine the health of the database, and trigger an automatic failover to switch the roles of the mirror database and the principal database when the principal database is abnormal.
Thus, there is no impact to data sync between my principal and mirror. In addition, you can focus on Mirroring States (SQL Server)
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".