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 »
Every write an update statement touching +50 million commands in a single transaction? Ever on a table being Published in Transaction Replication? How about to a subscriber half way around the world or on a satellite connected network? While nothing in Replication design prevents, there may be challenges that should be considered when making large
Read More »
How to fix SQL 2008 R2 Replication objects not being created on Subscriber Chris Skorlinski Microsoft SQL Server Escalation Services Just a heads up if you are still running any version of SQL Server prior to SQL Server 2012 SP1 for Transactional Replication and the following hold true: 1) Use ‘initialize with backup’ To initialize
Read More »
ReplTip – Bulk Updates with Transactional Replication by Taiyeb Zakir We’re seeing several customers performing bulk updates on the Publisher. Consider for example a table with 10 rows and 2 columns C1 and C2 and we run this update. Update table set C1 = “Something” This updated 10 rows as one set, but when Log
Read More »
In the middle of a huge phased migration from SQL 2000 to SQL 2008 we noticed the SQL 2008 publisher\distributor was causing blocking when replicating data changes to the SQL 2000 subscriber. We discovered the SQL Server 2005\2008\2012 Distribution Agent was configured to replicate as native SQL commands instead of default parameterized stored procedures. This
Read More »