Forum Discussion
Transaction Replication - How does the Identity range work.
Hi All, I am setting up a transactional replication for MS SQL 2019. The team is using Identitiy columns as the PK on the tables. I know they are a issue when a failover happens. I would li...
Thanks for your response. But I want to know what values can I set for
Publisher Range Size
Subscribers Range Size
Next Range Starting Value
Also If my publisher goes down Will the subcriber use the Seeding from 1 or will it start from the Next Range Starting Value ?
Or Do I need to manually update the Seeding everytime it Fails and reset after I restore my Publisher.