locked
Timeout Error in database RRS feed

  • Question

  • Hi Team,

    In Error log i m getting below error any suggestion on this.

    Error:

    The mirroring connection to "TCP://" has timed out for database "abac" after 10 seconds without a response.  Check the service and network connections.

    Tx


    subu

    Friday, May 11, 2012 1:44 PM

Answers

  • This is most likely due to a transient network connectivity issue. If you are not using synchronous mirroring with automatic failover, it is a little less of a worry, since the mirroring session will usually catch up without causing any other issues.

    It is pretty common to have to change the mirroring timeout value for a mirrored database to a higher value than the default of 10 seconds in order to avoid this issue. I would try changing it to 15 seconds and see if that helps.


    Glenn Berry
    http://sqlserverperformance.wordpress.com/
    http://www.twitter.com/GlennAlanBerry
    Please click the Mark as Answer button if a post solves your problem!

    Friday, May 11, 2012 10:32 PM

All replies