One of my Facebook followers sent me an interesting situation, where he faced error related replication or change data capture.
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.
SQL SERVER – Initializing a Merge Subscription Without a Snapshot
Books Online says initializing a merge subscription without a snapshot may be deprecated, while the transactional version has no such note. Plan for it.
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.
SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)
My review of Pro SQL Server 2005 Replication by Sujoy Paul, a good book for any novice who wants to learn database replication setup and maintenance.
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.