SQL server replication - QueueReader Agent job

Question

Hi,

We have SQL server 2014 with transaction replication setup & all is good.

Now we have prepared parallel server installed SQL server 2022 on it. Restored all the databases from 2014.

Now when we generate replication scripts from 2014 & execute on 2022, replication is setup but an additional job of Queue reader is created (we do not have this job in 2014 replication).(Our subscription is not updateable in 2014 and 2022).

Should we simply disable the Queue reader job & it will be fine ?

Any thoughts. Thanks

Answer 1

See Replication Queue Reader Agent and after answer the question yourself, if you could or not.

Answer 2

Hi @Zahid Butt

Our subscription is not updateable in 2014 and 2022

Disable the job and then rebuild the publication.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi,

I went through below link:

https://www.sqlservercentral.com/forums/topic/remove-or-disable-queue-reader-agent

Since I am right now test server , so I executed scripts to create replication along with qreader.

Then I dropped this job & replication is still working fine. That mean I can skip qreader job creation line in the script while I execute on production server.

Thanks everyone for your time.