September 12, 2012 at 2:09 am
Hi,
OS - win 2008 R2 x64 enterprise edition
SQL - MSSQL R2 x64 enterprise edition with sp2
Pl. suggestion me, how to avoid these erroe in feature? are they required to apply any patch in sql side?
But, I am not enable any threshold like unsent log, unrestore log, commit overhead etc.. now its running system default values.
Principal server
-----------------
Message
Error: 1479, Severity: 16, State: 2.
Message
The mirroring connection to "TCP://servername:5023" has timed out for database "dbname" after 10 seconds without a response. Check the service and network connections.
Mirror server
-------------
sourcespid21s
Message
Error: 1474, Severity: 16, State: 1.
Message
Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://servername:5022'.
September 12, 2012 at 3:04 am
are you using the default mirroring timeout value?
What is the result of the following query?
select mirroring_connection_timeout from sys.database_mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 3:10 am
Perry Whittle (9/12/2012)
are you using the default mirroring timeout value?What is the result of the following query?
select mirroring_connection_timeout from sys.database_mirroring
Yes, currently default mirroring time out values.
query result
mirroring_connection_timeout = 10
September 12, 2012 at 3:42 am
I assume that DB Mirror environment is configured such a way that it utilizes synchronous mirroring without automatic failover and no wittness.
If the Mirrorred instance doesnt not receive any responses to Ping for 10 seconds from Principal and mirror server.
Pl. confirm, should I change this default value? at principal server end
ALTER DATABASE <dbname> SET PARTNER TIMEOUT 60
September 12, 2012 at 4:52 am
it needs to account for network latency so yes change it to whatever you require
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2018 at 1:22 pm
It solved my problem. Thanks a million!
vic
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply