Solved

SQL Server Log Shipping Reports Generation

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create an aggregate function 9 34
Sql server, import complete table, using vb.net 9 34
Problem to setup GUI 11 33
Better way to make a query with date filter. 5 26
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

772 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