Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
psikadelik
Starting Member
5 Posts |
 Posted - 2009-07-23 : 10:18:33
|
| Using SQL Server 2008Situation:DB 'Server1' with merge replication (done with wizard) - @pub_identity_range = 10000 and @identity_range = 1000According to Microsoft (http://technet.microsoft.com/en-us/library/ms152543.aspx) :The @pub_identity_range parameter, which controls the identity range size for republishing allocated to Subscribers with server subscriptions (required for republishing data). All Subscribers with server subscriptions receive a range for republishing, even if they don't actually republish data.The @identity_range parameter, which controls the identity range size initially allocated both to the Publisher and to Subscribers with client subscriptions.Then i created 2 subscriptions (1 server (db 'Server2') type and 1 client type (db 'POS1') and i got this constraints:Server 1([articleID]>=(1) AND [articleID]<=(1001) OR [articleID]>(1001) AND [articleID]<=(2001))--Server 2([articleID]>(24001) AND [articleID]<=(25001) OR [articleID]>(25001) AND [articleID]<=(26001))--POS1([articleID]>(46001) AND [articleID]<=(47001) OR [articleID]>(47001) AND [articleID]<=(48001))When i try to create a second publication on db 'server2' i get the error : "The republisher's republishing range obtained from its publisher is not large enough to allocate the specified @pub_identity_range."In my understanding of Microsoft explication, Server2 should have a 1.000 range to his own use and a (10.000-1.000 = 9.000) to distribute to his subscribers.Is this correct?Can someone help me out with this?Is there any way of thins this publication-republication using the wizard ?Thanks for your help. |
|
|
|
|
|
Republising Data