June 8, 2010 at 3:33 am
Hi all - a quick question hopefully. I have been asked to support a mirror implementation, and today it looks to have failed over as the principles have moved. However I can not find any entries in the eventvwr or SQL logs as to when this happened.
Can anyone tell me where to look to find exactly which databases failed over and at what time?
Thanks
June 8, 2010 at 4:44 am
have a look at the log of the Witness server, in there it should show when the connection to the principal timed out
June 8, 2010 at 7:31 am
I am getting a lot of the following on all servers in the logs
Message
The mirroring connection to "TCP://XXXXXX:XXX" has timed out for database "XXXX" after 10 seconds without a response. Check the service and network connections.
But I am not sure if this will have triggered the failover?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply