Category: Replication

The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory.

The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory.

Shortly after configuring a new SQL Server 2012 server as a pull subscriber to a publication on a SQL Server 2008 Publisher/Distributor, we began receiving the following error message from the replication agents/jobs: The root cause, after much searching and testing theories, was permissions on the subscriber COM directory. The fix was to simply grant…

Read More Read More

Procedure to Validate SQL Server Replication Convergence

Procedure to Validate SQL Server Replication Convergence

Today I’m posting a turn-key solution for those of you out there supporting SQL Server replication. The purpose of the stored procedure created by the script provided below is simply to leverage a little-known, but very useful, tool provided by Microsoft for the sake of convergence validation (all your table based articles are identical between the publisher and subscriber(s)).

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0×800

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0×800

So today I’m posting about an issue with SQL Server replication. This particular posting is with regards to a SQL Server 2008 Enterprise 64-bit platform and transactional replication. The story goes like this: I was asked to add some new tables in a published DB to the transactional publication on the publisher to get replicated…

Read More Read More