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.

This entry was posted on Monday, August 24th, 2009 at 2:19 pm and is filed under Microsoft, SQL Server . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply