How to check DR database(disaster recovery) and production database in sync

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  July 10, 2010 at 12:20 am

  #157069

  We are performing a power down activity in our environment.So we made the DR server up.Now we need to sync up the databases after power up if any changes happened at DR site.How can we find out whether the two databases are in sync

• David Sorauer

  SSCrazy

  Points: 2874

  More actions

  July 12, 2010 at 12:39 am

  #1191325

  You can look at the database mirroring monitor, or run this query (and ensure all mirroring databases are SYNCHRONIZED):

  select * from sys.database_mirroring

  where database_id > 4

  and mirroring_state NOT like '%NULL%'