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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy