February 14, 2008 at 10:23 am
Hi guys i m facing this problem when i m runing merage ruplication.
Error messages:
The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199417)
Get help: http://help/MSSQL_REPL-2147199417
Not enough range available to allocate a new range for a subscriber. (Source: MSSQLServer, Error number: 20668)
Get help: http://help/20668
Failed to allocate new identity range. (Source: MSSQLServer, Error number: 21197)
Get help: http://help/21197
March 27, 2008 at 6:51 am
Hi,
I have also the same problem. After the installation of SQL SP2 it is still the same. I have 2 servers. One (publisher) is in Bratislava, Slovakia and the second one is in Melbourne (subscriber). THey are connected via the Internet. Replication was running without any troubles more then 3 years. Now it runs, but several times per day I have to restart the server in Bratislava to run it again.
If anybody is able to help us I would appreciate it a lot.
regards
Ivan
March 27, 2008 at 11:22 am
Try following the instructions in the error message?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply