September 24, 2013 at 4:34 am
When logshipping is configured, we know that along with LS Backup/copy and restore jobs, LS ALert jobs are also created, which alerts whenever the defined threshold for the backup or restore has crossed. I want to know where these alert messages are logged apart from msdb..
September 24, 2013 at 4:46 am
This will help http://www.mssqltips.com/sqlservertip/2553/different-ways-to-monitor-log-shipping-for-sql-server-databases/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:54 am
Thank Bhuvanesh.
My exact question is whenever an alert job fails, where it stores the information. Does it directly writes to msdb?
September 24, 2013 at 4:58 am
Yes .
From above pasted link
--Query to check the job history error messages if any
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
WHERE [message] like '%Operating system error%'
--Query to check the Log Shipping errors
SELECT *
FROM [msdb].[dbo].[log_shipping_monitor_error_detail]
WHERE [message] like '%Operating system error%'
--------------------------------------------------------------------------------
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 11:11 pm
Thanks Bhuvnesh.
So it seems, alert job directly writes to msdb.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply