Author: ReplTalk

Example of troubleshooting Distribution Agent errors

I 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.  The –output
Read More »

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 [crayon-5cbd786307c7d286758876/] Observe the subscriber is not created with compressed vardecimal storage resulting in additional storage requirements on subscriber for
Read More »