<div>
did you check GUI and sql server error log/<br />
Database Mirroring History <br />
<a href="http://msdn.microsoft.com/en-us/library/ms365382(SQL.90).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms365382(SQL.90).aspx</a>&nbsp;<br />

</div>


did you check GUI and sql server error log/
Database Mirroring History
http://msdn.microsoft.com/en-us/library/ms365382(SQL.90).aspx [http://msdn.microsoft.com/en-us/library/ms365382(SQL.90).aspx] 


<div>
Technically this works. Except this makes you scroll through thousands of entries since it creates one every minute. There's got to be a way to run a SQL query to find this information out. 
</div>


Technically this works. Except this makes you scroll through thousands of entries since it creates one every minute. There's got to be a way to run a SQL query to find this information out.

<div>
<div class="content wysiwyg-content">
We are using mirroring between two SQL 2005 Standard edition installations. ServerA is the host of the principal database. ServerB is the host of the mirrored version. <br />
<br />
Is there a way to determine the history of flips? Meaning how do we determine when the databases have flipped. We don't see a specific eventid and even so it would be nice to see this in a report or a SQL query. The reason it flipped would be even better!<br />
<br />
Thanks :)
</div>
</div>


We are using mirroring between two SQL 2005 Standard edition installations. ServerA is the host of the principal database. ServerB is the host of the mirrored version. 

Is there a way to determine the history of flips? Meaning how do we determine when the databases have flipped. We don't see a specific eventid and even so it would be nice to see this in a report or a SQL query. The reason it flipped would be even better!

Thanks :)

Determine when SQL Principal and Mirror Flipped

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.