June 19, 2013 at 7:23 am
Hi,
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.180spid27sSQL 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):
Warning6/19/2013 1:26:20 AMspid10sError: 1479, Severity: 16, State: 1.
OK6/19/2013 1:26:20 AMspid10sThe 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.
environment :
Sql server 2005 SP3 standard edition
windows server 2003
Database mirroring configured with HA
Please let me know if you need more details....
June 19, 2013 at 8:29 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply