website challenges
Sorry, but Repltalk.com website is having a few challenges today and we’re working to get these corrected. There has been a critical error on this website. Chris Skorlinski
Author: ReplTalk
Initialize Subscriber from Differential Backup
My colleague Lubín Hidalgo Carro, Microsoft SQL Support Engineer, was helping a customer initialize the Transactional Replication subscriber via backup\restore method as documented here and on docs.microsoft. https://blogs.msdn.microsoft.com/repltalk/2010/03/16/deep-dive-on-initialize-from-backup-for-transactional-replication/ https://docs.microsoft.com/en-us/sql/relational-databases/replication/initialize-a-transactional-subscription-from-a-backup The main steps shown below are to create the publication, change allow init from backup, then take a full backup. Create the publication using user interface
Read More »
Replication and Distributed Availability Groups Limitation
Currently Microsoft SQL Server Always Distributed Availability Groups does not support one global listener for the entire distributed availability group. Replication technology is currently is configured using a single Listener, therefore until either Distributed Availability Groups support a single Listener or Replication support multiple Listeners, Distributed availability groups and Replication environments are not compatible. When
Read More »
Customizing Distribution Agent Stored Procedures
You may have the need to customize the stored procedures used by the Distribution Agent to apply changes to the Subscriber. For example, if in your particular environment replicated DELETEs often fails with “Row not found” error, by now you’ve most likely change the Distribution Agent to use the “Continue on Errors” Profile or added
Read More »
Change Tracking fixes in SQL 2014 SP4 CU4
The Cumulative Update 4 for SQL 2014 SP3 contains these important fixes for Change Tracking technology. Cumulative Update Package 4 for SQL Server 2014 SP3 – KB4500181 https://www.microsoft.com/en-us/download/details.aspx?id=57663 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 https://support.microsoft.com/en-us/help/4500403/fix-tlog-grows-quickly-when-you-run-auto-cleanup-procedure-in-sql-serv FIX: Syscommittab cleanup causes a lock escalation that will
Read More »