locked
Mirroring Session Drops RRS feed

  • Question

  • We've implemented mirroring between two identical servers.  Sporadically, the mirroring session will drop and the ERRORLOG reflects the errors below at the exact time the mirroring session becomes suspended.  We do not manage our back end network since we use a dedicated hosting environment at a remote location.  Is this issue solely caused by network connectivity issues, or are there other factors at work? 

    2007-07-16 04:24:37.24 spid23s     Error: 1453, Severity: 16, State: 1.
    2007-07-16 04:24:37.24 spid23s     'TCP://192.168.215.92:5022', the remote mirroring partner for database 'evestment', encountered error 1204, status 4, severity 19. Database mirroring has been suspended.  Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance.
    2007-07-16 04:24:48.46 spid23s     Error: 1479, Severity: 16, State: 1.
    2007-07-16 04:24:48.46 spid23s     The mirroring connection to "TCP://192.168.215.92:5022" has timed out for database "evestment" after 10 seconds without a response.  Check the service and network connections.

    Monday, July 16, 2007 5:57 PM

Answers

  • The mirroring gets suspended if any one of the partners is not accessible.....if the principal or mirror is down, the mirroring cant be established and hence it reflects as suspended in the database status in the object explorer.......it can also be due to network issues as you say........

    when the mirroring session is paused or if redo errors occurs in the mirror.......even in those two scenarios the mirroring gets suspended...refer,

    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

    in that link refer database mirroring dynamics

    Monday, July 16, 2007 8:59 PM