Hi,
Looks like you are configuring PULL Subsribtion,
From Server A to B
And Server A to C
Server A to server B is configured.
See , for Server A to server C, I Could explain you the process via
Enterprice manager, Goto Server C and create distributor( looks like you
have already created), Goto Server C-> Replication-> Configure....
Select Option, you will get the window for configuration, Can set up
Distributor there.
And after setting up the destructor.
As you're a is already a publisher so just be on server C and right
select the Replication->Subscriber->New Pull Subscription...
And configure the subscriber.
My one cent.:)
HTH.
Thank you.
Vinay Thakur
-----Original Message-----
From: Stephen Dyckes
[mailto:mssqldba-ezmlmshield-x28089665.[Email address protected]
Sent: Wednesday, April 30, 2008 9:09 AM
To: LazyDBA Discussion
Subject: Re: Replication
There can be only one!
Distributor per Publisher that is.
Stephen Dyckes
-----Original Message-----
From: Richard Wadsworth <mssqldba-ezmlmshield-x95178017.[Email address
protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Wed Apr 30 07:53:02 2008
Subject: Replication
Hi,
I currently replicate data from Server A (SQL2k) to Server B (SQL2K),
with the distributor at B
I know want to start replicating data from Server A to Server C
(SQL2005) with the distributor at C.
When I set up replication I don't normally get the option of C as a
distributor (it is configured at C as one) and when I run:
Exec sp_adddistributor @distributor = 'Server C' ,@password ='XXX'
It says "Repl_ditributor" already exists (the name of the linked server
in for A --> C).
how can I run the SP to create a different named entry in sysservers to
mark server C as another distributor?!
Any help appreciated.
Many thanks
Rick
This email and any files transmitted with it are strictly confidential.
It is for the intended recipient only. If you have received the email in
error please notify the author by replying to this email. If you are not
the intended recipient you must not disclose, distribute, copy, print or
rely on this email in anyway. Any views which are expressed in this
e-mail are solely the personal opinion of the author and do not
necessarily represent the views of CC Automotive Group Limited.
Registered in England and Wales No: 819414. Registered office: Nixon
Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this
email message has been swept for the presence of known computer viruses
before transmission.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this e-mail message is intended only for
the personal and confidential use of the recipient(s) named above. This
message may be an attorney-client communication and/or work product and
as such is privileged and confidential. If the reader of this message is
not the intended recipient or an agent responsible for delivering it to
the intended recipient, you are hereby notified that you have received
this document in error and that any review, dissemination, distribution,
or copying of this message is strictly prohibited. If you have received
this communication in error, please notify us immediately by e-mail, and
delete the original message.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page