Updated posting on regenerating symmetric keys Chris Skorlinski Microsoft SQL Server Escalation Services. I came across a great posting by Laurentiu Cristofor [MSFT] called “ SQL Server 2005: How to regenerate the same symmetric key in two different databases...

Follow the Data in Transactional Replication Chris Skorlinski Microsoft SQL Server Escalation Services Abstract Many technology solutions use a STORE and FORWARD model to move data though out the business. It begins when source data change is...

Lessons learned updating 100 millions rows. Chris Skorlinski Microsoft SQL Server Escalation Services Yes, post mostly Replication or High Availability topics, but I found this interesting enough to share on my ReplTalk blog.  These are the troubleshooting...

Push v. Pull Merge Replication Chris Skorlinski Microsoft SQL Server Escalation Services I hope to answer the question “What is the difference between Push and Pull Merge Replication?” in this blog posting. As you know Merge Replication is all about merging...

SQL Server Transaction Replication Bounded Update (or why my UPDATE was transformed into an DELETE/INSERT pair) By José Moreira B. Neto Microsoft SQL Server Escalation Services   Bounded Update is the term used to describe certain types of UPDATE...

How to move a Published Table to a new File Group Chris Skorlinski Microsoft SQL Server Escalation Services I recently needed to move a Transactional Replicated table to a new File Group.  There are a couple of documented Schema changes that can...

Update Statistics fails with Error Number: –1073548784 "Could not allocate space for object 'dbo.SORT” Chris Skorlinski Microsoft SQL Server Escalation Services · ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error Number: -1073548784 Executing...

Using Power Shell to script out Replication Chris Skorlinski Microsoft SQL Server Escalation Services While troubleshooting customer’s Replication scenarios we often ask for the “script” used to recreate their replication environment.  The BLOG posting...

Stop and checked your Virtual Log Files (VLFs) Chris Skorlinski Microsoft SQL Server Escalation Services Is your transaction log over 5gb?  Have you checked to see how many Virtual Log Files (VLFs) exists in your transaction logs?  If not, I...

SQLSaturday, Toronto, Sept 17, 2011, check it out! Chris Skorlinski Microsoft SQL Server Escalation Services If you are in the Toronto area, or can be, on Saturday, Sept 17th, 2011, check out SQLSaturday workshop.  Great opportunity to meet with...

Using sp_repldone to SKIP a transaction Chris Skorlinski Microsoft SQL Server Escalation Services The steps in this posting covered advanced topics is SQL Server Transactional Replication.  If you are unsure on how or when to use these steps, DON...

How to reference a Folder as a Drive Letter Chris Skorlinski Microsoft SQL Server Escalation Services While assisting a customer with a SQL 2000 Replication configuration on Windows 2003 we need to reference the \ReplData folder as a Driver Letter. ...

How to run sp_browsereplcmds on a Distribution db backup Chris Skorlinski Microsoft SQL Server Escalation Services From time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing.  When...

REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ PROBLEM : I have a SQL Server 2005 replicating...

Replication: Unable to Synchronize subscribers via Web Synchronization reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ Problem : The upload message to be sent to Publisher 'XXX' is...

SQL 2005 Merge Agent Blocking in MSmerge_generation_partition_mappings Chris Skorlinski Microsoft SQL Server Escalation Services If you observe blocking in the SQL Server 2005 Merge Agent script out the “nc1MSmerge_generation_partition_mappings” index...

Initial Merge Synchronization not using Bulk Insert Chris Skorlinski Microsoft SQL Server Escalation Services Working with a customer to setup a large subscriber we noticed the Merge Agent was NOT doing a BULK INSERT, but instead was doing row-by-row...

Distribution Agent unable to STREAM when replicating as TSQL Chris Skorlinski Microsoft SQL Server Escalation Services New for SQL 2008 is the ability for the Distribution Agent to push updates to the Subscriber using multiple connections.  This...

Merge agent failing with “Cannot insert duplicates rows into table “ tablename ”. Violation of PRIMARY KEY constraint” during initialization. Sateesh Yele Microsoft SQL Server Support Last week, I worked on replication case where the merge agent was failing...

Distribution agent failing with “ procedure was called with an incorrect number of parameters” . Sateesh Yele Microsoft SQL Server Support Transactional replication allows you to specify how data changes are propagated from the Publisher to Subscribers...

Very Slow Data Repartitioning in SQL Server Replication with Precomputed Partitions Chris Skorlinski Microsoft SQL Server Escalation Services Here is a great posting by Kevin Locke on a problem he encountered when data modifications occurred near the...

MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed. Chris Skorlinski Microsoft SQL Server Escalation Services Error messages: Unable to decide if MakeGeneration is needed. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199360...

Reducing Impact of Large Updates on Merge Replication Chris Skorlinski Microsoft SQL Server Escalation Services One key parameter to consider when performing batch updates against tables enabled for Merge Replication is 'generation_leveling_threshold...

Clearing Resolved Merge Replication Conflicts Chris Skorlinski Microsoft SQL Server Escalation Services Content provided by: Steve Dybing, Microsoft SQL Server Support Background on Merge Conflicts ---------------------------------------------- When a...

Tools and Techniques for ReplTalk Blog Postings and Video Captures (Heading 1) Someone asked me to put together a list of tools and techniques we used when writing our ReplTalk BLOG posting and video clips. Sounds like a good idea so here it is! Content...