Solved

SQL Server Log Shipping Reports Generation

Posted on 2013-06-25
3
579 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

911 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

24 Experts available now in Live!

Get 1:1 Help Now