Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Determine when SQL Principal and Mirror Flipped

Posted on 2009-04-14
3
Medium Priority
?
688 Views
Last Modified: 2012-05-06
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 :)
0
Comment
Question by:GCIT_Manager
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24194658
did you check GUI and sql server error log/
Database Mirroring History
http://msdn.microsoft.com/en-us/library/ms365382(SQL.90).aspx 
0
 

Author Comment

by:GCIT_Manager
ID: 24195810
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.
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1500 total points
ID: 24196385
check table  msdb.dbm_monitor_data  
but use : the stor proc:
sp_dbmmonitorresults
http://msdn.microsoft.com/en-us/library/ms366320(SQL.90).aspx
 --
more
Monitoring Mirroring Status
http://msdn.microsoft.com/en-us/library/ms365781(SQL.90).aspx
 
--
more:

sys.dm_db_mirroring_connections  
 http://sqlblogcasts.com/blogs/simons/archive/2005/11/15/Database-mirror-state-information.aspx
----
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question