Post reply

mirroring connection timeout

  • January 15, 2010 at 3:57 am

    #219257

    Hi All

    Just a quick question i have SQL 2005 mirrored using a witness the connection is timing out after 10seconds im going to change it to 30 seconds as it is causing problems.

    I have a script for this but looking to run a query to show it is currently at 10 seconds so i can run this to ensure it has changed it to 30 seconds once i have ran ALTER DATABASE ........ SET PARTNER TIMEOUT 30

    Can anyone help please?

    Thanks

  • January 15, 2010 at 6:34 am

    #1104155

    you can check the time out value from this table

    SELECT * FROM sys.database_mirroring

  • January 15, 2010 at 8:12 am

    #1104232

    Thanks very much thats brilliant ta

Viewing 3 posts - 1 through 2 (of 2 total)

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