Extending SQL Mirror Time Outs

You might get the below event error if Database mirroring fails, or the auto failover for some reason does not work.

This below error will be found only on the witness server.

 

Event Type:    Error
Event Source:    MSSQL$SQLEXPRESS / MSSQLSERVER
Event Category:    (2)
Event ID:    1479
Date:        21/08/2009
Time:        4:29:18 PM
User:        N/A
Description:
The mirroring connection to "TCP://xxxxx.domain.com.au:5022" has timed out for database "YourDatabaseName" after 10 seconds without a response.  Check the service and network connections.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

You can easily increase the time of the time out of the mirror timeouts.

ALTER DATABASE yourdatabase SET PARTNER TIMEOUT 30

This will increase you database time out to 30 seconds.


One Response to “Extending SQL Mirror Time Outs”

  • Extending SQL Mirror Time Outs | Brad Marsh's Weblog Says:

    Amazing Proxies…

    You might get the below event error if Database mirroring fails, or the auto failover for some reason does not work. This below error will be found only on the…

Leave a Reply