REPLTalk covers Using and Tuning SQL Replication

April 24th SQLSaturday Workshop in Atlanta GA on CDC and Merge Replication If you’re in the Atlanta, GA area Saturday April 24th, check out SQLSaturday. Its a great way to meet with other SQL Server professionals listen to some great presentations. Some...

Distribution Agent Fails with error Msg 0, Level 20, State 0, Line 0 Chris Skorlinski SQL Server Escalation Services Any Cox Microsoft Premier Field Engineer We recently encounter the a problem where Replication Distribution Agent failed with error below...

Merge Agent blocked by sp_mergemetadataretentioncleanup Chris Skorlinski SQL Server Escalation Services Problem Customer observes high latency in SQL Server 2005 Merge replication. In sysprocesses you see that Merge agents are being blocked by another...

How SQL Server 2005/2008 Replication resumes interrupted snapshot delivery Anurag Sharma Microsoft SQL Server Escalation Services Background In many cases customer often have large databases published and creating a snapshot of such large database is...

Using Transactional Replication to support REPORTING and DIASTER RECOVERY Chris Skorlinski SQL Server Escalation Services Here are some thoughts on using Transactional (or Peer-2-Peer) Replication Subscriber to support both REPORTING and DISATER RECOVERY...

Visual Studio Utility to Compare 2 SQL Server Databases Chris Skorlinski Microsoft SQL Server Escalation Services During performance troubleshooting we often need to look at difference between two different databases. We’ve used SQL Server Tablediff Utility...

How to run “sp_change_users_login” for all users in a database Chris Skorlinski Microsoft SQL Server Escalation Services Following a user database restore the database had orphaned users. We used TSQL commands below to build a list of sp_change_users_login...

What Immediate_sync means in Transactional Replication José Moreira Neto Microsoft SQL Server Escalation Services sp_addpublication parameter: [ @immediate_sync=] 'immediate_synchronization' Immediate_sync has a default of FALSE. independent_agent...

Windows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager...

What are Merge Replication Anonymous Subscribers José Moreira Neto Microsoft SQL Server Escalation Services Particularities of Merge Anonymous Subscribers In Merge Replication, anonymous subscriptions are required if you want to create a subscription...

Replication Jobs fail with error code 0x6fd Chris Skorlinski SQL Server Escalation Services Doing Replication demonstrations on my laptop I’ll notice a Distribution Agent is not running. I’ll start the Agent and Refresh, but it still shows as Not Running...

How to use Merge Replication Centralized Logging Feature Eric Lucht Microsoft SQL Server Escalation Services Centralized troubleshooting refers to the ability to generate detailed Merge agent log files on both client and Web server (for Web Synchronization...

How to change the reporting level for the Merge Replication ReplMerg.log Eric Lucht Microsoft SQL Server Escalation Services Logging Options When the Merge subsystem is initialized, agent logging is automatically enabled using default values. The Agent...

Investigation into why Query Performance was slower on Merge Subscriber Chris Skorlinski Microsoft SQL Server Escalation Services Are the queries to pull data from the Merge Subscribe taking longer then when executed on the Publisher? Looks like it is...

Troubleshooting Snapshot Agent hang Chris Skorlinski, Microsoft SQL Server Escalation Services I recently got a customer call where the SQL 2008 Snapshot Agent appeared to hang when started from SSMS. As you can see, pop-up status window shows “Starting...

Tracking Merge Agent Performance using Distribution database system tables Amit Banerjee Microsoft SQL Server Support TSQL Code: MS_MergeAgentStatistics.sql script located on SkyDrive MergePerformance or TechNet Code Share I have sometimes found the need...

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...

If you’re in the US, check out SQLSaturday conference in your local city. These are a great way to keep up on latest SQL topics from both local and national speakers without going to SQL PASS. I recently presented at the Charlotte, NC SQLSaturday where...

The Difference between alt_snapshot_folder and AltSnapshotFolder Sometimes MS SQL Replication developers use similar names for similar meaning but which can have very different results. These settings both specify alternate location for the Snapshot files...

Executing batch UPDATE commands on Publisher and its affect on Transactional Replication José Moreira Neto Microsoft SQL Server Escalation Services Problem 1: batch updates 1) A single update command can generate a transaction with thousands of commands...

Troubleshooting Error: The merge process was unable to perform data validation on article Sateesh Yele Microsoft SQL Server Support I would like to share information about an interesting Replication issue I recently worked. Customer was getting unusual...

How to create P2P replication to enable table partition switching Sateesh Yele Microsoft SQL Server Support Peer-2-Peer Replication Wizard provides no options to enable table partition switching. There are 2 ways to enable this feature. 1) create the...

Tune Replication Performance using PacketSize Contributed by: Karol Korasadowicz Depending on type of data being replicated and network throughput adjusting the PacketSize parameter for the Distribution Agent may increase your overall Transactional Replication...

Divide and Conquer Transactional Replication using Tracer Tokens Chris Skorlinski Microsoft SQL Server Escalation Services As we know, Transactional Replication moves data from the Publisher to the Distributor then to the Subscribers. When working, data...

  Tips to improve performance when applying Snapshot in Transactional Replication (updated) Chris Skorlinski Microsoft SQL Server Escalation Services 1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add...