?
Solved

SQL Server Log Shipping Reports Generation

Posted on 2013-06-25
3
Medium Priority
?
606 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
PortletPaul earned 1500 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

764 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