The mirroring connection has timed out for database after 10 seconds without a response, mirroring_connection_timeout

Problem

SQL Server 2005 database mirroring is not working. Automatic failover does not happen when the principal or mirror servers are down. You will get the following error messages in the event logs.

	Event Type:	Error
	Event Source:	MSSQLSERVER
	Event Category:	(2)
	Event ID:	1479
	Date:		4/24/2008
	Time:		12:00:43 AM
	User:		N/A
	Description:
	The mirroring connection to "TCP://xxxx.yourdomain.com:5022" has timed out 
	for database "yourdatabase" after 10 seconds without a response.  
	Check the service and network connections.
	

Solution

The default mirroring time out value is 10 seconds. You need to increase this number if you have more and more database transactions.

  1. Open your principal database with SQL Server Management Studio.
  2. Open a new SQL query windows and execute the following statement
		ALTER DATABASE yourdatabase SET PARTNER TIMEOUT 30
	

Related Resources

Navigator

Other Knowledgebase Articles

Basic SQL Hosting

# of Domains: 4
# of SQL Server Databases: 4
Disk Space: 50GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $4.99
More Information About Basic Shared SQL Server Hosting Plan

Express Hyper-V Hosting

Dedicated Memory:2GB
Disk Space: 100GB
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $11.99
More Information About Express Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core X3440 CPU
RAM: 16GB RAM
Disk: 2x120GB SSD + 300GB SATA
RAID: RAID 1
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Dedicated SQL Server with SSD
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting