November 17, 2016 at 5:33 am
We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server.
Database mirroring connection error 4 'The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)''
Database mirroring connection error 4 '10054(An existing connection was forcibly closed by the remote host.)'.
Database mirroring connection error 2 'Connection attempt failed with error: '10060(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)'.'
I have verified telnet to mirroring ports which is working from both sides.
Any thoughts?
November 17, 2016 at 7:07 am
Try restarting the mirroring endpoints:
-- To find out the name of the endpoint - execute from the primary
SELECT * FROM sys.endpoints
ALTER ENDPOINT Mirroring STATE=STOPPED
ALTER ENDPOINT Mirroring STATE=STARTED
If communication between the endpoints does not restart after you execute the scripts, execute the scripts on the database mirror. However, the database may enter a "Suspended" state after you do this. If this issue occurs, execute the following SQL script:
ALTER DATABASE <Database Name> SET PARTNER RESUME
November 17, 2016 at 7:45 am
I have tried stopping and starting endpoints,Issue is not resolved.
we are facing this issue once or twice in a week and the principal server databases are failing over to mirror server.
throwing the message as Database mirroring connection error 4 'The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)'' in the sqlserver logs.
November 17, 2016 at 8:08 am
DBA_007 (11/17/2016)
We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server.Database mirroring connection error 4 'The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)''
Database mirroring connection error 4 '10054(An existing connection was forcibly closed by the remote host.)'.
Database mirroring connection error 2 'Connection attempt failed with error: '10060(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)'.'
I have verified telnet to mirroring ports which is working from both sides.
Any thoughts?
Are you using a witness server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:12 am
yes, for automatic failover.
November 17, 2016 at 8:29 am
can you supply more detail on the placement of the principal, mirror and witness instances, are they on separate sites for instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:31 am
They are all in the same domain
November 18, 2016 at 5:26 am
Does anyone have a solution to this problem
December 6, 2016 at 9:32 am
DBA_007 (11/17/2016)
They are all in the same domain
I asked if they were on separate sites, not domains.
Please provide more detail on the mirroring configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply