Forum Discussion
Solved
Log Reader Agent throwing errors on Azure SQL Managed Instance
I configured Azure SQL Managed Instance for transactional replication, it is a publisher with local distributor. I got it set up and the snapshot agent runs successfully, but the log reader agent is ...
- This issue has been resolved - the issue is I was dropping/re-creating via scripts in our non-prod environment. When doing cleanup, I did not remove the replication Sql Agent jobs, so I had about 20 log reader agent jobs running. Once I removed all the obsolete jobs, it worked as expected.
This issue has been resolved - the issue is I was dropping/re-creating via scripts in our non-prod environment. When doing cleanup, I did not remove the replication Sql Agent jobs, so I had about 20 log reader agent jobs running. Once I removed all the obsolete jobs, it worked as expected.