Sunday, May 29, 2011

To change the time-out value for mirroring database (high-safety mode only)

You can change timeout value for database mirroring.

use master
go
ALTER DATABASE  db_name SET PARTNER TIMEOUT 60

go

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

--Output
60