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