locked
The mirroring connection to has timed out for database after 10 seconds without a response. Check the service and network connections. RRS feed

  • Question

  • I am getting following error in production server. is this network error?

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

    Thanks!



    • Edited by R987654 Friday, June 16, 2017 5:57 PM
    Friday, June 16, 2017 5:54 PM

All replies

  • It could be, you might want to make your mirroring session more resilient to these network hiccups by setting your timeout parameter to something larger, ie:

    ALTER DATABASE dbName SET PARTNER TIMEOUT 20

    Here I am setting it to 20s.

    Friday, June 16, 2017 5:57 PM