Today morning our prod database has been failed over from principal to mirror....Please let me know what might be the reason....
Here are the errors..
Principal server error log :
2013-06-19 01:26:27.180 spid27s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
Witness server log :
6/19/2013 1:30:18 AM, SQL Server Error Log on xxxxxxx is Warning.
SQL Server instance xxxxxx recorded 1 error log message requiring attention.
The message are shown below in context (if applicable):
Warning 6/19/2013 1:26:20 AM spid10s Error: 1479, Severity: 16, State: 1.
OK 6/19/2013 1:26:20 AM spid10s The mirroring connection to "TCP://xxxx.ds.xxxx.com:9030" has timed out for database "xxxxxx" after 10 seconds without a response. Check the service and network connections.
Sql server 2005 SP3 standard edition
windows server 2003
Database mirroring configured with HA
Please let me know if you need more details....