I have 2 databases mirrored. They both uses same Primary, same Mirror and same Witness. All servers are SQL Server 2008. The first DB is OK and shows fully connected and synchronized in Database Mirroring Monitor but the second DB shows disconnected between Mirror and Witness. A restart of the Witness does not help. A manual failover back and forth of the second DB does not help either.
When I checked sys.database_mirroring_witness in Witness server, I discovered that regarding the second DB, the Mirror server name (TCP://srv.mycompany.com:5022) is missing from mirror_server_name column. Is there a way to fix this?
I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done. Is there another way to fix this issue without removing and re-creating mirroring?