Error: 1474, Severity: 16, State: 1.

  • Dear All,

    mirroring disconnected it shows error in the log as following order...

    Unknown,Error: 1479<c/> Severity: 16<c/> State: 1.

    Unknown,The mirroring connection to "xxxx" has timed out for database "xxxx" after 10 seconds without a response. Check the service and network connections.

    Unknown,Error: 1479<c/> Severity: 16<c/> State: 1.

    Unknown,The mirroring connection to "xxx" has timed out for database "xxxx" after 10 seconds without a response. Check the service and network connections.

    Unknown,Database mirroring is inactive for database 'xxx'. This is an informational message only. No user action is required.

    Unknown,Database mirroring is inactive for database 'xxxx'. This is an informational message only. No user action is required.

    Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.

    Unknown,Database mirroring connection error 4 'An error occurred while receiving data: '64(failed to retrieve text for this error. Reason: 15105)'.' for xxx.

    Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.

    Unknown,Database mirroring connection error 4 'An error occurred while receiving data: '64(failed to retrieve text for this error. Reason: 15105)'.' for xxx.

    Error: 1474, Severity: 16, State: 1.

    Database mirroring connection error 4 'An error occurred while receiving data: '64(failed to retrieve text for this error. Reason: 15105)'.' for 'TCP://........'.

    When monitoring mirroring both principle and mirror are in disconnected status.

    Status it is showing cannot connect to the mirror instance.

    Database mirroring connection is in Asynchronous mode.We are using sql server 2008.

    please help me..How to coneect again and to find the exact root cause.how to establish the connection and resent the unsent log.

    Looking for quick response.Its very urgent......

  • Somewhat old for an urgent issue, but did you actually try to telnet port 5022 on both the primary and secondary servers to make sure they can communicate with each other. Log on to the primary, and telnet to secondary 5022, and vice versa.

    It sounds like the two servers simply cannot talk to each other.

    Steve

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

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