Wednesday, September 14, 2016

Mirroring Connection Timed out 10 seconds - Severity 16 Error

If your mirroring is working fine and we are getting repeated alerts for Severity 16 that mirroring has timed out after 10 seconds than you run below command on principle server to set time out to 60 seconds.

Problem: 

SQL Server Alert System: 'Severity 16' occurred on \\ServerName\InstanceName

DATE/TIME:        9/14/2016 7:31:43 AM

DESCRIPTION:   The mirroring connection to "TCP://ServerName.domain.com:5022" has timed out for database "MirroredDatabase" after 10 seconds without a response.  Check the service and network connections.


COMMENT:        (None)


JOB RUN:             (None)

Solution: 

ALTER DATABASE MirroredDatabase SET PARTNER TIMEOUT 60

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home