question

5QL53rv3r avatar image
5QL53rv3r asked

Can you increase (more than 10sec) the timeout period in a mirroring witness config

I just had a repeat of an issue where the SQL 2005 (SP3) mirroring config got really confused and i ended up with 2 principal databases. I know it can be decreased, but I was wondering if there is any way to increase the communication timeout that the witness server uses to over 10 sec?

Many thanks
M

database-mirroring
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered

It looks like you cant set it below 5 seconds but anything over that looks possible. . . http://msdn.microsoft.com/en-us/library/bb522476.aspx

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.