Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Sanity Check Mirror (2008 Std Edition)

Author  Topic 

uberman
Posting Yak Master

159 Posts

Posted - 2009-07-31 : 05:22:54
We are (probably) going to be moving from a 2000 log shipped system to a 2008 mirror settup (currently in testing)

Using SQL Std 2008 is there a relatively easy way to "check" the mirror is up to date, looking at the acutal data in the db?

With log shipping we break it every now and then and log into the seconday db to see it has the latest data, is there an "easy" way to do this with a mirror (pause, inspect, reconnect)

If we had Enterprise I could snapshot the mirror and inspect that, but we dont!

Advice/pointers appreciated.
   

- Advertisement -