Improve company productivity with a Business Account.Sign Up

x
?
Solved

SQL Server Log Shipping Reports Generation

Posted on 2013-06-25
3
Medium Priority
?
629 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 50

Accepted Solution

by:
Paul 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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…
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.

595 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