SQL Mirroring Fail-over

Owned by Nick Judson
Last updated: Mar 04, 2016
1 min read
In certain scenarios, a mirror will break after fail-over and the mirror endpoints need to be restarted: https://support.microsoft.com/en-us/kb/2490051
The easiest fix is to use the following on both primary and secondary:

 

--get the name of your mirror endpoints
select name from sys.database_mirroring_endpoints


-- stop and start them
ALTER ENDPOINT Endpoint_Mirroring STATE=STOPPED;
GO
ALTER ENDPOINT Endpoint_Mirroring STATE=STARTED;
GO