Author: Chris Skorlinski [MSFT]

Clarification on MSDN Initialize a Transactional Subscription from a Backup

I hope this blog posting will provide some clarification into the MSDN article providing steps on how to initialize a transactional subscription from a backup. First I want to clarify the @backupdevicename parameter. The article reads like the “DISK = “should be included in the parameter, it should not. For a physical device, specify
Read More »

Repltalk – Replication Tuning Knobs – LogReader

Chris SkorlinskiMicrosoft SQL Server Escalation Services If you’re familiar with Microsoft SQL Server Replication technology you already know each Replication Agent has various parameters or knobs you can set via Agent Profile or SQL Agent job parameter. This series of posts provide insight into tuning Replication performance using these knobs. Following the 80-20 rule, 80%
Read More »

Script to show Replication Topology

Chris Skorlinski, Microsoft SQL Server Escalation Services I came across this forgotten but very handy script from my friends Suhas and Gaurav to display your Replication topology. The output below is from SQL 2016 sample publications using AdventureWorksLT. ============================================================= REPLICATION TOPOLOGY ============================================================= SELECT THE PUBLICATION-SUBSCRIPTION PAIR FOR SCOPING THE CASE =============================================================   SQL2016
Read More »