Category: ReplTalk Blog

The insert failed. It conflicted with an identity range check constraint

Share this PostTaiyeb Zakir Microsoft SQL Server Escalation Support Services When replicating identity columns https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-identity-columns  and using Auto Identity management, you need to make sure ranges are defined properly. The default “ranges” for automatic identity range management, while good 20 years ago, may need to be tuned for today’s higher workloads. Share this Post

Transaction Log won’t truncate when using Snapshot Replication to Azure SQLDB

Share this PostChris SkorlinskiMicrosoft SQL Server Escalation Services Customer encountered transaction log growth for a Published SQL Server 2016 database while nightly refreshing Azure SQLDB. We discovered the default publication setting “replicate_dll” was still enabled. SELECT [description],[name],[replicate_ddl] FROM <your published database>.[dbo].[syspublications] description name replicate_ddl —————————————————— ———- ————- Snapshot publication of database ‘AdventureWorks2014’ Customers 1 (1
Read More »

Clarification on MSDN Initialize a Transactional Subscription from a Backup

Share this PostI hope this blog posting will provide some clarification into the MSDN article providing steps on how to initialize a transactional subscription from a backup. https://msdn.microsoft.com/en-us/library/ms147834.aspx 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
Read More »

ReplTalk – Oracle Publishing Error ORA-01455

Share this Postby Chris Skorlinski, Microsoft SQL Server Escalation Services Oracle Publishing, now deprecated in SQL Server 2014, provides ability to use Oracle server as a Transactional Replication Publisher to a Microsoft SQL Server subscriber. Oracle Publishing Overview http://technet.microsoft.com/en-us/library/ms151229.aspx This feature was as designed as an Oracle to Microsoft SQL Server migration tool.  Other customers
Read More »