Issue : After window server restarted database mirroring is stop working, Mirroring endpoint was broken and getting connection handshake failed.
Troubleshooting checklist
- Checked SQL Server error log on principal server
Database Mirroring login attempt failed with error: ‘Connection handshake failed. The certificate used by this endpoint was not found: Certificate expired. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State 85.’
Restarted endpoint
ALTER ENDPOINT mirroing STATE= stopped
ALTER ENDPOINT mirroing STATE= started