Author: ReplTalk

Deep Dive on Initialize from Backup for Transactional Replication

Sateesh Yele | Microsoft SQL Server Support How to initialize the subscriber from backup Create the publication using user interface Replication Wizard. Under subscription options for the publication, set “allow initialization from backup files” to true Create a new full backup of the publisher database. If you have existing full backup of the publisher database,
Read More »

Subscriber bloating when VarDecimal Compressed settings not transferred

When using compressed “VarDecimal Storage Format Enabled” on Transactional or Merge published tables you’ll discover this setting is not applied to subscribers leading to table bloating. Database Properties Table Properties Try This: Publish table with varDecimal USE [AdventureWorks2017] GO CREATE TABLE [dbo].[DecZero]( [ID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [F1] [decimal](23, 2) NOT NULL,
Read More »

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
Read More »

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
Read More »