Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 R2 Log Shipping Monitor reports Expand / Collapse
Author
Message
Posted Thursday, March 8, 2012 7:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 2,316, Visits: 850
Hi,

I have a prod server, primary (A) shipping logs to a secondary DR server (B). Everything is working as it should and I have setup B as the monitor server also. I was looking at the reports ("Transaction Log Shipping Status") on both A & B servers and server A only gives Backup Log info and server B only provides Copy and Restore info which kinda makes sense but I was expecting the monitor server report to provide ALL the details on one report. Am I missing something?

Thanks

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1263641
Posted Thursday, March 8, 2012 12:33 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:29 PM
Points: 2,007, Visits: 6,077
No, you're not missing anything. Sadly the log shipping report only gives you information for the primary or secondary. You're best bet is going to be a roll your own report scenario where you grab the dataset from each into SSRS (or reporting method of your choosing).



Shamless self promotion - read my blog http://sirsql.net
Post #1263888
Posted Friday, March 9, 2012 2:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 2,316, Visits: 850
Thanks for the reply! SSRS it is then.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1264197
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse