Tag: Upgrade

CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016

Chris Skorlinski [MSFT] Product Updates, Troubleshooting April 7, 2017

This problem was brought to our attention recently by one of our customers. CDC LogScan job fails, possible Error Message: Log Scan process failed in processing log records. Operand type clash: int is incompatible with uniqueidentifier Operand type clash: int is incompatible with datetime The Log-Scan Process failed to construct a replicated command from log
Read More »

SQL Server Replication Upgrade Strategies

Chris Skorlinski [MSFT] Best Practices February 3, 2017

In the recent past, we have seen questions on the strategy/steps on upgrading a replication topology especially from customers using SQL Server 2008/2008 R2 or running SQL Server on Windows Server 2008 and 2008 R2. We have outlined the most common topologies for replication and the possible upgrade paths for all releases from SQL Server
Read More »