Transaction Log Shipping Status Report by Email

Question

Transaction Log Shipping Status Report by Email

Ben Curry

Old Hand

Points: 378
More actions
July 11, 2008 at 3:05 am

#123767

Hi Forum,
I wish to run the "Transaction Log Shipping Status Report" on my secondary server at selected intervals and have it email the report to recipients.
Does anyone have any idea how this could be done?
Thanks,

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

MannySingh SSChampion Points: 12465 More actions · Answer 1

Configure DatabaseMail or SQLMail on the Server and if you Auto Apply the Log using a JOB, use a STEP in the JOB, to send out Email message.

Maninder
www.dbanation.com

Ben Curry Old Hand Points: 378 More actions · Answer 2

Thanks Mani but I might not have been clear enough.

I don't want to email everytime a log goes gets applied to the secondary DB.

Within SQL 2005 there is a "transacation log shipping status" report which you can run which gives you the status of the copy and restore statuses of the log to the DB. I would like this to run every week and output the report to an email.

RPSQL Hall of Fame Points: 3229 More actions · Answer 3

select * from log_shipping_plan_history put this statement into job

Ben Curry Old Hand Points: 378 More actions · Answer 4

Hi,

I have tried this but I do not have a table called log_shipping_plan_history.

I have looked under the available tables from the MSDB database and this is not one of them.

I am on SQL Server 2005 if that helps.

Thanks,

HelmutR Ten Centuries Points: 1184 More actions · Answer 5

Hi Ben,

maybe you're question is already answered (I think so). But you can find the result of the Transaction Log Shipping Report in the Tables:

msdb..log_shipping_monitor_primary (for the primary server) and in

msdb..log_shipping_monitor_secondary (for the secondary server)

Regards

Helmut

@STLSQLGuy Default port Points: 1476 More actions · Answer 6

this returns the details of the SSMS report. Not formatted as nicely unfortunately

USE MASTER

GO

exec sys.sp_help_log_shipping_monitor

thanks, ERH

revathi.j76 SSC Enthusiast Points: 140 More actions · Answer 7

revathi.j76

SSC Enthusiast

Points: 140

August 4, 2011 at 8:53 pm

#1364070

Thanks..

Really it helped me..