Mirroring Failover/Failback history

  • Hello,

    I am a SQL DBA newbie, and I am trying to get the failover/failback history for one of our mirrored servers. I am able to get the the failover history from event viewer but do not know how to the get the failback history. Your help is greatly appreciated!

  • You can simply look for the respective database recovery events in the SQL Server Error Log and keep track of them. When DB mirroring failover happens, SQL Server will perform Crash Recovery which gets logged in the SQL Server error log. In other words, you can't access the database untill REDO portion has been taken care(Ignore Fast recovery for now)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply