Post reply

Transactional Replication

  • November 12, 2025 at 2:56 pm

    #4684239

    Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a SQL 2019 server for reporting purposes.

    7 of the publications work as expected, the 8th does the snapshot, but fails when populating the subscriber. It fails on the same table/file every time and moves on to the next file if I drop the other from the publication. The failure is an invalid EOF.

    The replication worked fine on the previous server and as I mentioned earlier, the other publications work well.

    The files are being written to a local SSD. The server has 600GB of RAM, and plenty of cores.

    Any thoughts

    Thanks

    Kirk

  • November 12, 2025 at 3:17 pm

    #4684252

    Is SSRS giving you an error message? If so, screenshot please. Try updating the DataSource on ssrs for the failed report.

    • This reply was modified 5 hours, 31 minutes ago by Tav29.

  • November 12, 2025 at 3:57 pm

    #4684261

    Strange. All subscribers same version? Same collation?

  • November 12, 2025 at 6:02 pm

    #4684313

    Everything is exactly the same. Driving me crazy

  • November 12, 2025 at 6:09 pm

    #4684314

    Not sure if my email replies are getting posted to this thread or not.

    SSRS is unaware of any issues.

    One thing I left out, my apologies. All the publications and subscriptions were created from a script generated on a 2019 server then executed on the 2022 box.

    LI've also created a subscription on the publication server and it failed with the same error.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply