sp_mergemetadataretentioncleanup fails after installing SQL 2012 SP2

Chris Skorlinski Microsoft SQL Server Escalation Services Unfortunately we discovered the fix for this problem was not included in SQL Server 2012 SP2 CU1 or CU2.  We anticipate the fix will be included in the next cumulative update for SQL Server 2012. We’re testing the work around below, so far no issues. ———————————————————————— — STOP…

2

Microsoft SQL Replication Between Windows Azure Virtual Machines

Chris Skorlinski Microsoft SQL Server Escalation Services You can use SQL Server Replication technologies to move data between local on premises SQL Server to SQL Server running in Windows Azure Virtual Machines or between Windows Azure Virtual Machines.  Similar to move data between non-trusted corporate domains, keys are 1) use SQL Server Authentication and 2)…

3

SQL Server Profiler showing 9003 Exception when CDC is configured

While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler. “The log scan number (42:358:1) passed to log scan in database ‘<db name>’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this…

0

Using MaxCmdsInTran with “sync with backup” breaks Transactional Replication

Holger Linke Microsoft SQL Server Escalation Services Abstract: This article describes an issue with SQL Server Transactional Replication that was detected recently. If you have configured the Log Reader agent to use the MaxCmdsInTran parameter, and also have configured the Distribution database to use the “sync with backup” option, you may experience a failure of…

0

WHY CENTRAL MERGE SUBSCRIBERS ARE NOT SUPPORTED

Holger Linke Microsoft SQL Server Escalation Services Abstract Provides details and explanations why SQL Server Merge Replication does not support central subscriber topologies. This fact was originally stated in SQL Server Books Online and further documented in KB article KB 2750005, but is still causing some misconceptions and confusion. This blog article will provide additional…

0