SET PARTNER TIMEOUT mirroring

Question

SET PARTNER TIMEOUT mirroring

abdalah.mehdoini

Ten Centuries

Points: 1012
More actions
December 13, 2018 at 4:57 am

#382446

HELLO EVERYONE
Who has an idea what exactly is this command for?
ALTER DATABASE [abd_prod] SET PARTNER TIMEOUT 30
thanks
December 15, 2018 at 12:54 am

This was removed by the editor as SPAM

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

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

e4d4 SSCertifiable Points: 5777 More actions · Answer 1

Hi https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-database-mirroring?view=sql-server-2017

"TIMEOUT integer
Specifies the time-out period in seconds. The time-out period is the maximum time that a server instance waits to receive a PING message from another instance in the mirroring session before considering that other instance to be disconnected."

abdalah.mehdoini Ten Centuries Points: 1012 More actions · Answer 2

[citation]

e4d4 - jeudi 13 dÃ©cembre 2018 Ã 08h15[/ b]

Bonjour https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-database-mirroring?view=sql-server-2017

"TIMEOUT integer
SpÃ©cifie le dÃ©lai d'expiration Le dÃ©lai d'attente est le dÃ©lai maximal pendant lequel une instance de serveur attend de recevoir un message PING d'une autre instance de la session de mise en miroir avant de considÃ©rer que cette autre instance est dÃ©connectÃ©e. "

[/citation]

and if I do not specify this parameter, what will be the default value that will be taken?

Michael L John One Orange Chip Points: 27055 More actions · Answer 3

abdalah.mehdoini - Thursday, December 13, 2018 9:15 AM
[citation]
e4d4 - jeudi 13 dÃ©cembre 2018 Ã 08h15[/ b]
Bonjour https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-database-mirroring?view=sql-server-2017
"TIMEOUT integer
SpÃ©cifie le dÃ©lai d'expiration Le dÃ©lai d'attente est le dÃ©lai maximal pendant lequel une instance de serveur attend de recevoir un message PING d'une autre instance de la session de mise en miroir avant de considÃ©rer que cette autre instance est dÃ©connectÃ©e. "
[/citation]

and if I do not specify this parameter, what will be the default value that will be taken?

Did you read the article provided? It explains it in there.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/