Forum Discussion

pscruggs's avatar
pscruggs
Copper Contributor
Nov 10, 2023

Log Shipping Job Errors In Always On Availability Group

I am trying to set up log shipping on my two database instances that are a part of an Always On availability group. I have configured the primary for log shipping, and I configured the secondary the same way using the script that was generated when configuring the primary. The log shipping is working fine on the primary database, but the log shipping jobs running on the secondary database are all failing.

 

The log shipping jobs fails on the secondary with the error "The target database, ***, is participating in an availability group and is currently not accessible for queries. "

 

The alert fails on the secondary since it thinks that no logs have been shipped in 60 minutes. However, the primary has been shipping logs just fine.

 

It is my understanding that since the secondary database is a part of an availability group, the jobs should know this and succeed.

 

I am using SQL Server 2022.

No RepliesBe the first to reply