Category: Try This

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 »

Customizing Distribution Agent Stored Procedures

ReplTalk Try This May 20, 2020

Share this PostYou may have the need to customize the stored procedures used by the Distribution Agent to apply changes to the Subscriber. For example, if in your particular environment replicated DELETEs often fails with “Row not found” error, by now you’ve most likely change the Distribution Agent to use the “Continue on Errors” Profile
Read More »

Walkthrough Publisher, Distributor, Subscriber in AlwaysOn Availability Groups

Chris Skorlinski [MSFT] Try This March 9, 2019

Share this PostUPDATE: 4/10/2020 The steps below walk through setting SQL Server 2016 Replication Publisher, Distributor, and Subscriber each in an Always On Availability Group with one set of replicas residing one 1 subnet and 2nd set on another subnet simulating 2 different data centers (Pub1, Dist1, Sub2) <–> (Pub2, Dist2, Sub2). More Information: Configure
Read More »

Deep Dive on Initialize from Backup for Transactional Replication

ReplTalk Troubleshooting, Try This January 3, 2019

Share this PostSateesh 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
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 »