Why DR site alert is coming red in report.

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  December 8, 2011 at 4:50 am

  #247991

  I have configured logshipping between dc and dr for 6 databases.for 1/2 an hour replication time.

  All 6 dbs are ok but on DR site mangement studio Logshipping report is giving alert in red color for one db.

  on DC it is not giving anything.

  Jobs are OK on both site.Size is same on both side.Timely txn files are creating

  Alert job is ok(Created on DC side.).

  Thanks

• danschl

  SSCertifiable

  Points: 5770

  More actions

  December 9, 2011 at 1:49 pm

  #1419620

  usually when it is red either the copy or the restore jobs have had a problem.

  usually you can tell which one by which report column is behind

  look at the job history of the one that is behind for more information