Mirroring Error 1479, 1474

  • 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'.

  • 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" 😉

  • 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

  • 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

  • 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" 😉

  • 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