Category: Inside Replication

Initialize Subscriber from Differential Backup

ReplTalk Inside Replication, ReplTalk Blog, Try This August 25, 2020

Share this PostMy colleague Lubín Hidalgo Carro, Microsoft SQL Support Engineer, was helping a customer initialize the Transactional Replication subscriber via backup\restore method as documented here and on docs.microsoft. https://blogs.msdn.microsoft.com/repltalk/2010/03/16/deep-dive-on-initialize-from-backup-for-transactional-replication/ https://docs.microsoft.com/en-us/sql/relational-databases/replication/initialize-a-transactional-subscription-from-a-backup The main steps shown below are to create the publication, change allow init from backup, then take a full backup. Create the publication using
Read More »

New Merge subscriber fails with sp_MSsetconflicttable

ReplTalk Inside Replication July 17, 2019

Share this PostI’ve not seen this problem for year, but it came up again today. We were following the steps to setup a Merge subscriber using Backup\Restore from the Publisher. The database was very large, no filtering, two subscribers, each with complete match set of data from the publisher. Backup\Restore works great, saves time pushing
Read More »

Reset topology using “Replication Support Only”

ReplTalk Inside Replication January 14, 2019

Share this PostIf you need to reset your Replication topology you can quickly rebuild subscribers using the “no initialize” also called “Replication Support Only (RSO)”. WARNING: These steps are designed to remove ALL of your Replication configuration and settings, recreating with new metadata tables. The RSO option skips the Snapshot data reinitialization phase. It only pushed
Read More »

Example of troubleshooting Distribution Agent errors

ReplTalk Inside Replication January 8, 2019

Share this PostI thought it would be helpful to post a Replication Distribution Agent troubleshooting case to show more about replication components and troubleshooting approaches. Problem: SQL Server Distribution Agent reported “Failed” in Replication Monitor. To capture text of the message we added the following parameters to the Distribution Agent job and restarted the job.
Read More »

Subscriber bloating when VarDecimal Compressed settings not transferred

ReplTalk Inside Replication, Try This January 1, 2019

Share this PostWhen 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)
Read More »