Solved

SQL Server Log Shipping Reports Generation

Posted on 2013-06-25
3
577 Views
Last Modified: 2013-08-08
Hi,

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.


Thanks.....
0
Comment
Question by:angnanesh
  • 2
3 Comments
 

Author Comment

by:angnanesh
ID: 39274283
I have configured Secondary server as monitoring server.
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39276779
a more do it yourself approach?
Log Shipping Tables and Stored Procedures
e.g.
use msdb
select * from dbo.log_shipping_monitor_alert
select * from dbo.log_shipping_monitor_error_detail
select * from dbo.log_shipping_monitor_history_detail
select * from dbo.log_shipping_monitor_primary
select * from dbo.log_shipping_monitor_secondary
select * from dbo.log_shipping_primaries
select * from dbo.log_shipping_primary_databases
select * from dbo.log_shipping_primary_secondaries
select * from dbo.log_shipping_secondaries
select * from dbo.log_shipping_secondary
select * from dbo.log_shipping_secondary_databases

& there are some log shipping scripts here:
http://muralidatabaseadministration.blogspot.com.au/2012/10/scripts-to-monitor-log-shipping.html
0
 

Author Comment

by:angnanesh
ID: 39395308
Thank U
0

Featured Post

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now