SQL server replication - QueueReader Agent job

Zahid Butt 641 Reputation points
2023-12-04T14:50:25.91+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,281 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,926 Reputation points
    2023-12-04T15:09:43.5366667+00:00

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

    0 comments No comments

  2. LiHongMSFT-4306 25,571 Reputation points
    2023-12-05T02:44:13.72+00:00

    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.

    0 comments No comments

  3. Zahid Butt 641 Reputation points
    2023-12-05T18:31:30.1733333+00:00

    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.

    0 comments No comments