The Synchronous Mirroring on sql server 2k8 is giving error:w00t:

Question

Post reply

The Synchronous Mirroring on sql server 2k8 is giving error:w00t:

forsqlserver

SSCoach

Points: 18902
More actions
May 4, 2011 at 4:08 am

#237651

The Synchronous Mirroring on sql server 2k8 is giving error in event viewer:
The mirroring connection to "TCP://PS11I0713VM262.XYZ.in:5022" has timed out for database "XYZBESMgmt" after 10 seconds without a response. Check the service and network connections.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 1

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/96648622-7b32-4106-a20b-9ef04c33362c/

http://msdn.microsoft.com/en-us/library/ms190913.aspx

open your principal database on SSMS SQL Server Management Studio and then click on new query and then pass this statement

ALTER DATABASE yourdatabase SET PARTNER TIMEOUT 30

My Blog
www.aureus-salah.com

forsqlserver SSCoach Points: 18902 More actions · Answer 2

This is the production server I cant run it,First I have to detect the reason why error has started.Earlier it was not coming.

Thanks

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 3

Syed Jahanzaib Bin hassan (5/4/2011)
http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/96648622-7b32-4106-a20b-9ef04c33362c/
http://msdn.microsoft.com/en-us/library/ms190913.aspx
open your principal database on SSMS SQL Server Management Studio and then click on new query and then pass this statement
ALTER DATABASE yourdatabase SET PARTNER TIMEOUT 30

All this may do is mask the actual problem, it is not necessarily a solution to be blindly applied.

The OP is correct if this is a recent change that research is needed to determine what may be causing the issue. In the end it may be tdetermined that the correct course of action may be to alter the timeout time.

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Thanks...

But I want to just confirm that will Mirroring be OK or Not?

How Do I check this? If I create database snapshot of Mirror datasbase but I dont know How snapshot is compared to a Database?

Thanks

sachnam SSCrazy Points: 2317 More actions · Answer 5

forsqlserver (5/5/2011)
Thanks...
But I want to just confirm that will Mirroring be OK or Not?
How Do I check this? If I create database snapshot of Mirror datasbase but I dont know How snapshot is compared to a Database?

Snapshot is a kind of image of your database at a particular point in it. It has no data of its own intially until data get changed in the original DB.

i am not sure whether it would help you or not. but you could try selecting some highly transactional tables on your principal and check if the record count is same in prinicipal and on mirrorred snapshot or not. Or you could also use datetime type of columns in your database to check the same thing.

Apparently it seems like some slowness in your N/w. Have you checked with your N/w Guys that is there any intermittent N/w response.

So far as your mirroring is concerned it should not be affected as such because you are running in a synchronised manner the only bad thing which could happen in the broken connection btw Principal and Mirror and your prinicpal will work in an exposed manner. Faced the samiliar kind of issue once and it was because of N/w Fluctuation..

Regards,

Sachin