October 28, 2016 at 7:07 am
I have reconfigured logshipping but my LSAlert job on the primary is still failing.
On the secondary the transaction log shipping status report is showing OK, logs are being copied and restored.
The transaction log shipping status report on the primary is showing restore/copied information from before it was recreated logshipping.
Please advise how i can resolve this?
October 28, 2016 at 2:36 pm
juniorDBA13 (10/28/2016)
I have reconfigured logshipping but my LSAlert job on the primary is still failing.On the secondary the transaction log shipping status report is showing OK, logs are being copied and restored.
The transaction log shipping status report on the primary is showing restore/copied information from before it was recreated logshipping.
Please advise how i can resolve this?
The tables used for monitoring could be stale. You can try updating those by executing sp_refresh_log_shipping_monitor on the secondary server.
Sue
November 1, 2016 at 9:56 am
I ran the following on the secondary
execute sp_refresh_log_shipping_monitor
@agent_id = 'B7EE4B00-364A-49F4-AC4A-391722F0E66D',
@agent_type = 1,
@database = 'Database',
@mode = 1
Getting agent ID from the below query
select *
from msdb.dbo.log_shipping_secondary_databases as sd
join msdb.dbo.log_shipping_secondary as s
on sd.secondary_id = s.secondary_id
The query executed but hasn't updated the report
November 1, 2016 at 3:08 pm
Have you verified all the backup logs are in the shared folder?
Have the latest logs been applied to the secondary?
Are there issues with the copy, restore jobs?
Sue
November 2, 2016 at 2:58 am
Yes backup log are in the shared folder.
The logs are being applied to the secondary.
No issues with copy/restore jobs.
Transaction log report showing correctly on the secondary.
On the primary, transaction log report is showing restore/copy information. Should it be showing this since this is completed on the secondary?
Would an instance restart fix the issue?
November 4, 2016 at 4:45 am
check the step history carefully, although theyre marked as successful there'll likely be a message indicating logs cannot be applied
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply