Forum Discussion

Singapore2024's avatar
Singapore2024
Copper Contributor
Feb 06, 2024

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...
Identity
replication
  • Singapore2024's avatar
    Singapore2024
    Copper Contributor
    Feb 06, 2024

    olafhelper 

     

    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. 

     

     

     

Resources