Timeout Error in database
-
2012년 5월 11일 금요일 오후 1:44
Hi Team,
In Error log i m getting below error any suggestion on this.
Error:
The mirroring connection to "TCP://" has timed out for database "abac" after 10 seconds without a response. Check the service and network connections.
Tx
subu
모든 응답
-
2012년 5월 11일 금요일 오후 1:49
Take a look at the following:
Thanks,
Andrew Bainbridge
SQL Server DBA
Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you -
2012년 5월 11일 금요일 오후 10:32중재자
This is most likely due to a transient network connectivity issue. If you are not using synchronous mirroring with automatic failover, it is a little less of a worry, since the mirroring session will usually catch up without causing any other issues.
It is pretty common to have to change the mirroring timeout value for a mirrored database to a higher value than the default of 10 seconds in order to avoid this issue. I would try changing it to 15 seconds and see if that helps.
Glenn Berry
http://sqlserverperformance.wordpress.com/
http://www.twitter.com/GlennAlanBerry
Please click the Mark as Answer button if a post solves your problem!- 답변으로 제안됨 Chad Churchwell 2012년 5월 16일 수요일 오전 2:04
- 답변으로 표시됨 Maggie LuoMicrosoft Contingent Staff, Moderator 2012년 5월 22일 화요일 오전 7:11
.png)
