InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:53:56 GMT20http://www.sqlservercentral.com/Forums/Topic1263641-1549-1.aspxThanks for the reply! SSRS it is then. :-)[b][i]qh[/i][/b]Fri, 09 Mar 2012 02:50:10 GMTquackhandle1975http://www.sqlservercentral.com/Forums/Topic1263641-1549-1.aspxNo, 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).Thu, 08 Mar 2012 12:33:05 GMTNicholas Cainhttp://www.sqlservercentral.com/Forums/Topic1263641-1549-1.aspxHi,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[b][i]qh[/i][/b]Thu, 08 Mar 2012 07:54:53 GMTquackhandle1975