locked
timeout make it 20 sec RRS feed

  • Question

  • Hi Team,

    last night we have face db failover in mirroing env..

    In the witness server in error log i have got the below error

    The mirroring connection to " xxx " has timed out for database "yyyy" after 10 seconds without a response. Check the services and network connection

    Now my plan was make it as 20 seconds

    2. How can do it 20 seconds? In which server i have to change 20 seconds ?

    using alter database commnad we have to do can you guys please suggest me the same.

    Thanks


    subu

    Monday, September 17, 2012 8:44 AM

Answers

  • Hi Subbu,

    to get the current partner timeout values run this query

    SELECT Mirroring_Connection_Timeout
    FROM sys.database_mirroring
    WHERE database_id = db_id('db_name')

    to change the TIMEOUT value run this query in the principle server.

    AlTER DATABASE dbname SET PARTNER TIMEOUT 20

    NOTE:replace dbname with your database name


    Ramesh Babu Vavilla MCTS,MSBI


    Monday, September 17, 2012 11:52 AM

All replies

  • Hi Subbu,

    to get the current partner timeout values run this query

    SELECT Mirroring_Connection_Timeout
    FROM sys.database_mirroring
    WHERE database_id = db_id('db_name')

    to change the TIMEOUT value run this query in the principle server.

    AlTER DATABASE dbname SET PARTNER TIMEOUT 20

    NOTE:replace dbname with your database name


    Ramesh Babu Vavilla MCTS,MSBI


    Monday, September 17, 2012 11:52 AM
  • Subbu,

    Check if you receiving this error is coming frequently and if it is coming then try to incresses some more Minuties

    ALTER DATABASE [AdventureWorks] SET PARTNER TIMEOUT 60

    Thanks,

    Maddy

    • Proposed as answer by maddy28 Thursday, September 20, 2012 3:56 AM
    Thursday, September 20, 2012 3:56 AM