Mirroring Error 1479, 1474

  • SQL Galaxy

    One Orange Chip

    Points: 29228

    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

    -------------

    source spid21s

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

  • Perry Whittle

    SSC Guru

    Points: 233794

    are you using the default mirroring timeout value?

    What is the result of the following query?

    select mirroring_connection_timeout from sys.database_mirroring

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • SQL Galaxy

    One Orange Chip

    Points: 29228

    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

  • SQL Galaxy

    One Orange Chip

    Points: 29228

    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

  • Perry Whittle

    SSC Guru

    Points: 233794

    it needs to account for network latency so yes change it to whatever you require

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • Egbon

    SSC Veteran

    Points: 291

    It solved my problem. Thanks a million!


    vic

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply