Jun 22, 2020 · Create new Transactional Replication from Scratch (using the scripts generated from the existing Replication) with replication support only Run snapshot jobs to ensure the creation of any …

Mar 16, 2020 · Replication fails with "Transaction log for database is full due to LOG_BACKUP" Ask Question Asked 5 years, 10 months ago Modified 5 years, 4 months ago

Nov 11, 2020 · I created a stored procedure on Server 2 to drop (pre replication) and create (post replication) schemabound entities on Server 2's subscriber database. (I've done this successfully in …

Mar 29, 2022 · I have a SQL Server 2016 database in one server and a SQL Server 2019 Standard Edition database in another server. Is it possible to use replication and pass data from 2016 to 2019?

Apr 19, 2016 · The database uses replication to publish to a different server. Assuming the database restore would break the replication, I tried to delete the replication and re-create it (we have a script …

Jan 9, 2015 · The image below shows a transaction replication problem that I am currently investigating. The image comes from the Replication Monitor. How can I get this information using T-SQL?

Mar 10, 2025 · We have deployed a transactional replication system using a SQL Server 2022 Standard Edition, with Publisher and Distributor roles (on the same machine) and two SQL Server Express …

Nov 14, 2018 · In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) Yes, there are easier ways to query from …

Oct 17, 2023 · Publisher is on SQL Server 15.0.4249.2. The subscriber is on 15.0.4280.7. It's a transactional publication using the publisher's distribution database. Last week I made a test table …

Oct 30, 2019 · I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message when I run the snapshot agent: 2019-10-30 12:32:41.59 Microsoft (R) SQL Server …