patternsqlMinor
Reconnect mirroring server SQL Server 2008 R2
Viewed 0 times
2008reconnectsqlmirroringserver
Problem
The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected).
What is the process to reconnect these servers?
What is the process to reconnect these servers?
Solution
Sometimes restarting the mirroring endpoint on the principal server will resolve this.
To do this use the following T-SQL.
To get the name of the endpoint.
See KB 2490051 for more details.
To do this use the following T-SQL.
ALTER ENDPOINT Endpoint_Name STATE = STOPPED
ALTER ENDPOINT Endpoint_Name STATE = STARTEDTo get the name of the endpoint.
SELECT * FROM sys.endpoints
WHERE type = 4See KB 2490051 for more details.
Code Snippets
ALTER ENDPOINT Endpoint_Name STATE = STOPPED
ALTER ENDPOINT Endpoint_Name STATE = STARTEDSELECT * FROM sys.endpoints
WHERE type = 4Context
StackExchange Database Administrators Q#10077, answer score: 6
Revisions (0)
No revisions yet.