March 12, 2013 at 5:51 am
Hi Guys
Just had one question in mind and looking for the answers.
In DB mirroring how many times principal server tries to connect to mirror server when principal server tries to make connection with mirror server ?
Scenarios is if connection get lost because of network or eighter manual or atomatic failover and when principal server tries to connect to mirror server and somehow connection could not established so how many times princiapl server will try to connec to mirror server?
And where we define this value in DB mirroring?
If anyone can advise on this would be great.
Thanks
--------------------------------------------------------------------------------
March 12, 2013 at 6:15 am
It's based on time rather than no. of attempts. The default value is 10 seconds - so if no successful ping is received in a 10 second period failover will occur. I assume the actual number of attempts in this period can vary.
The setting is partner timeout - you can see it in select * from sys.database_mirroring (field named mirroring_connection_timeout)
and set it with the command:
alter database set partner timeout value
where value is number of seconds.
March 12, 2013 at 6:23 am
Thanks for kind Advise
March 12, 2013 at 6:28 am
No problem, hope it helped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply