March 8, 2012 at 7:54 am
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
March 8, 2012 at 12:33 pm
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).
March 9, 2012 at 2:50 am
Thanks for the reply! SSRS it is then. 🙂
qh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply