Merge Replication Identity Ranges

25 pts.
Tags:
Merge replication
Replication
SQL Server 2005
SQL Server administration
What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of identity ranges for the subscription.""Error number: MSSQL_REPL-214719941" Is there a formula or Rule-of-thumb that we can use?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Basically you want to make sure that the ranges are large enough that you can’t run out of IDs between merges. If you do a merge every 1 hour and you add in 10000 new records per server per hour at peak you should have at least 12000 IDs in the range so that you don’t ever run out.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,360 pointsBadges:
    report
  • Ramapa
    So it sounds like if we have the schedule set to every 1 minute, we could set the ranges to say 1000? Does this value take in to consideration the 9 subscriptions ? Thanks for your response !!
    25 pointsBadges:
    report
  • Ramapa
    Additional question is then sub 1 starts at 1000 and sub 2 starts at 2000, what happens when it hits 1999? Does the range automatically get changed? There will be significant changes on both sides, Publisher and subscriber... Thanks again !
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following