/
SQL Mirroring Fail-over

SQL Mirroring Fail-over

Owned by Nick Judson
Last updated: Mar 04, 2016
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

Related content

Fail Over Deployment
Fail Over Deployment
Connexion
More like this
MongoDb Error State
MongoDb Error State
Connexion
More like this
Connexion 14.5 R2 (14.5.946)
Connexion 14.5 R2 (14.5.946)
Connexion
More like this
14.0 Release 3 (v14.0.7449)
14.0 Release 3 (v14.0.7449)
Connexion
More like this
Connexion 14.5 R15 (14.5.3646)
Connexion 14.5 R15 (14.5.3646)
Connexion
More like this
Advanced Database Details
Advanced Database Details
Connexion
More like this