SQL Server Log Shipping Reports Generation
Posted on 2013-06-25
I have configured log shipping for my five locations sql database server's (Primary) and my secondary sql database server as stand by. Every thing is working fine all the five location servers are creating backup as per the schedule and it is restoring on my secondary server.
Now I want to generate log shipping reports from all five server and view these reports on secondary server as a single report. I tried using the Log Shipping Status report by right clicking on the Server Name in Management Studio > Reports > Standard Reports > Transaction Log Shipping Status but it shows very generic report. I want detail report which will show all five server backup timing, restoration timing on secondary. A single dash board report.