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
During configuring replication on one of the server, I received following error. This is very common error and the solution of the same is even simpler. MSDTC on server is unavailable. Changed database context to publisherdatabase. (Microsoft SQL Server, Error: 8501) Solution: Enable “Distributed Transaction Coordinator” in SQL Server. Method…
Read MoreSQL SERVER – Initializing a Merge Subscription Without a Snapshot
During recent course of Disaster Recovery and Performance Tuning, I had very interesting conversation with students regarding Initializing a Merge Subscription Without a Snapshot and Initializing a Transactional Subscription Without a Snapshot. After the discussion when we were looking at MSDN pages one thing caught my notice was the note…
Read MoreSQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from…
Read MoreSQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft…
Read MoreSQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover) by Sujoy Paul (Author) Link to Amazon Quick Review: This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept…
Read More
SQL SERVER – Replication Keywords Explanation and Basic Terms
While discussing replication with Jr. DBAs at work, I realize some of them have not experienced replication feature of SQL SERVER. Following is quick reference of replication keywords I created for easy conversation.