Feeds:
Posts
Comments

Posts Tagged ‘SQL Replication’

SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on March 24, 2010 | 10 Comments »

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 1: Click on Start–>Control Panel->Administrative [...]

Read Full Post »

SQL SERVER – Initializing a Merge Subscription Without a Snapshot

Posted in Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on January 15, 2010 | 2 Comments »

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 on the top of the [...]

Read Full Post »

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on December 11, 2009 | 11 Comments »

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 any server. I have seen [...]

Read Full Post »

SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on September 5, 2009 | 9 Comments »

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 SQL Server, Error: 3724) Fix/Workaround/Solution: [...]

Read Full Post »

SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

Posted in Database, DBA, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, T SQL, Technology, tagged on October 13, 2008 | 2 Comments »

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 and methodology at one place. [...]

Read Full Post »

Older Posts »