Doubts with Log Shipping

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

vandana.1103 SSC Veteran Points: 204 More actions · Answer 2

Thank Bhuvanesh.

My exact question is whenever an alert job fails, where it stores the information. Does it directly writes to msdb?

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

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;-)

vandana.1103 SSC Veteran Points: 204 More actions · Answer 4

Thanks Bhuvnesh.

So it seems, alert job directly writes to msdb.

Cookies on SQLServerCentral