replication - Sql Server : How to query list of subscriptions and ...
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 …
How to Migrate complete Transactional Replication to other …
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 …
SQL Server Database Restore with Replication
High Level Overview: How can I restore a SQL DB that's involved in transactional replication with 5 pub/subs, without having to drop, create, & re-initialize (or re-snapshot) all the subs. Or at …
sql server - Pre- and Post- Snapshot Replication Scripts Not …
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 …
How to fix a messed up replication on MS SQL Server
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 …
sql server - must be enable as a Publisher - Database …
Jan 25, 2022 · I installed SQL Server 2017 on Centos 7 and used MSSM GUI for database replication configuration. when the distribution configuration process was successful until the …
Is it possible to use replication between 2 different SQL Versions?
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 …
sql server - RAM consumption constantly increasing - Database ...
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 …
What is the performance overhead of snapshot replication vs ...
Dec 13, 2021 · Given my requirements, what is the performance overhead of snapshot replication vs transactional replication on the production server? Is there any other recommended solution …
sql server - Primary key with "NOT FOR REPLICATION" option
NOT FOR REPLICATION indicates that when a record is replicated to this table, any value that is inserted into the identity column via the replication agent keeps it's original value from the …