Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring automatic failover Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 7:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:28 AM
Points: 94, Visits: 750
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.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.

environment :

Sql server 2005 SP3 standard edition
windows server 2003
Database mirroring configured with HA

Please let me know if you need more details....
Post #1465156
Posted Wednesday, June 19, 2013 8:29 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:15 PM
Points: 727, Visits: 1,417
Please don't double post:

http://www.sqlservercentral.com/Forums/Topic1465160-1549-1.aspx

Fraggle
Post #1465210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse