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

Taiyeb ZakirMicrosoft 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. When the range is full on the…


Inside Distribution Cleanup Watermark

Inside Distribution Cleanup Watermark The Distribution database is a cache of undistributed commands that the Distribution SQL Agent jobs are responsible to deliver to their subscribers.  This cache is populated by the Publisher LogReader Agent job as new data changes are detected. The primary tables holding the cache of undistributed data is MSrepl_transactions and MSrepl_commands….


LogReader errors ‘Validating publisher’ after AlwaysOn failover.

Chris Skorlinski Microsoft SQL Server Escalation Services Problem of the day: Transactional Replication was configured on a database in AlwaysOn Availability Group. When the group was failed over to synchronized secondary node Transactional Log Reader stopped working. Initial LogReader errors when failover occurs.  If configured correctly, LogReader will retry and reconnect to new Primary. 2018-02-21…