Multi publisher single subscrier Replication

I had a multi publisher single subscriber replication in my job and now i want remove it. i disabled the subscriber. Now if i disable the publisher and distributor then it gives me a error cannot drop the distribution DB because it is currently in use. this DB can never be dropped since there is at least one publisher at one time that accesses this DB everytime. How should I disable this publication.

Disable each Publisher, removing any publications caused by that Publisher. Leave the Distribution database until you are removing the final Publisher and then it 'should' be removable.

sql

MsSql7 merge replication error

Greetings colleagues!

I recently set up replication between a Windows2000/Mssql7 server set up as distributor/publisher, and outside the firewall, an NT4/Mssql7 server.

I tried to set up Merge replication and initially i got the error 14010 whenever i tried to push a publication from the dist./pub. to the subscriber. This i fixed by having an alias created within the domain "inside" the firewall protected area, for the server in the DMZ(which was known until then only by its IP number).
I simply canceled the test publications and recreated them.

At first glance everything seemed to work perfectly until i got the error for the merge agent: 20084 , subscription cannot be accepted by subscriber database, An error i understand only to appear in the case of PULL subscription, yet i had only used PUSH subscriptions from the dist./pub. server.

I have to admit i'm mystified by this error, and having perused books online, Microsoft/technet and other sources i'm no closer to solving the problem.

I would really appreciated any help in fixing the problem and get my replication running.
Thank you very much, Vincent Seghers, Programmer-Analyst
Gent.beThe problem turned out to be a reference to a server on its actual IP "name" and not its nam. I declared an Alias (lettername short, no special characters) in the Client Network utility and it worked fine from then on.

Originally posted by VincentJS
Greetings colleagues!

I recently set up replication between a Windows2000/Mssql7 server set up as distributor/publisher, and outside the firewall, an NT4/Mssql7 server.

I tried to set up Merge replication and initially i got the error 14010 whenever i tried to push a publication from the dist./pub. to the subscriber. This i fixed by having an alias created within the domain "inside" the firewall protected area, for the server in the DMZ(which was known until then only by its IP number).
I simply canceled the test publications and recreated them.

At first glance everything seemed to work perfectly until i got the error for the merge agent: 20084 , subscription cannot be accepted by subscriber database, An error i understand only to appear in the case of PULL subscription, yet i had only used PUSH subscriptions from the dist./pub. server.

I have to admit i'm mystified by this error, and having perused books online, Microsoft/technet and other sources i'm no closer to solving the problem.

I would really appreciated any help in fixing the problem and get my replication running.
Thank you very much, Vincent Seghers, Programmer-Analyst
Gent.be

msSQL2000 to mssql2005

I have set up a replication between mssql2000 to mssql2005
Mssql2000 is the publisher and mssql is subscriber.
And it work fine.
Then I remove the publication because I need to do spm Alter statement
against Tables in the database
When I try to add subscription
with @.sync_type = N'none' (In This case the data i alredy in the subscribers
databse)
I get theese error:
Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__328568A3'.
Cannot insert duplicate key in object '#3191446A'.
(Source: SRVIQDB03 (Data source); Error number: 2627)
Her is Add subscr.
use [Tellus_DB209]
exec sp_addsubscription @.publication = N'pub_Tellus_DB209_2005',
@.subscriber = N'RDASP21', @.destination_db = N'Tellus',
@.subscription_type = N'Push', @.sync_type = N'none',
@.article = N'all', @.update_mode = N'read only',
@.loopback_detection = N'True',
@.frequency_type = 64, @.frequency_interval = 0, @.frequency_relative_interval
= 0,
@.frequency_recurrence_factor = 0, @.frequency_subday = 0,
@.frequency_subday_interval = 0,
@.active_start_time_of_day = 0, @.active_end_time_of_day = 235959,
@.active_start_date = 20060202, @.active_end_date = 99991231, @.offloadagent =
0,
@.enabled_for_syncmgr = N'False', @.dts_package_location = N'Distributor'
What is this about.
What sp is SQL 2000? You may need to check this link to fix the problem.
http://groups.google.com/group/micro...5?dmode=source
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roger Nygrd" <roger@.askit.no> wrote in message
news:11u4op7pil83qf4@.corp.supernews.com...
>I have set up a replication between mssql2000 to mssql2005
> Mssql2000 is the publisher and mssql is subscriber.
> And it work fine.
> Then I remove the publication because I need to do spm Alter statement
> against Tables in the database
> When I try to add subscription
> with @.sync_type = N'none' (In This case the data i alredy in the
> subscribers databse)
> I get theese error:
> Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__328568A3'.
> Cannot insert duplicate key in object '#3191446A'.
> (Source: SRVIQDB03 (Data source); Error number: 2627)
> Her is Add subscr.
> use [Tellus_DB209]
> exec sp_addsubscription @.publication = N'pub_Tellus_DB209_2005',
> @.subscriber = N'RDASP21', @.destination_db = N'Tellus',
> @.subscription_type = N'Push', @.sync_type = N'none',
> @.article = N'all', @.update_mode = N'read only',
> @.loopback_detection = N'True',
> @.frequency_type = 64, @.frequency_interval = 0,
> @.frequency_relative_interval = 0,
> @.frequency_recurrence_factor = 0, @.frequency_subday = 0,
> @.frequency_subday_interval = 0,
> @.active_start_time_of_day = 0, @.active_end_time_of_day = 235959,
> @.active_start_date = 20060202, @.active_end_date = 99991231, @.offloadagent
> = 0,
> @.enabled_for_syncmgr = N'False', @.dts_package_location = N'Distributor'
> What is this about.
>