Synchronizing data between two SQL Server databases requires a latency target, change source, conflict rule, and recovery plan before tool selection.
SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase
Error 8501 says MSDTC on server is unavailable, often while configuring replication. Start the Distributed Transaction Coordinator service to fix it.
Merge Subscription Initialization Without a Snapshot
Initializing a merge subscription without a snapshot requires more than matching table names. Prepare the schema, data and replication metadata, account for local changes and plan recovery for the actual replication topology.
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.
SQL SERVER – Replication Keywords Explanation and Basic Terms
A quick reference of Replication keywords I wrote for Jr. DBAs: publisher, subscriber, distributor, publication and article, each explained in plain words.