Please Help

Hi all,
I need to solve a problem with SQL replication, I know very little about it,
and it wasn't me that set it up.
However we have 2 servers both with sql server 2000 Lets say server A & B
server A has been setup as the publisher & distributor with a transaction
push subscription to server B that has been setup as a subscriber.
I want this to work both ways but it doesn't seem to be replicating from
server B to A. Does anybody know what I can look into to check out what's
happening here?
Thanks
Gav> I want this to work both ways but it doesn't seem to be replicating
> from server B to A. Does anybody know what I can look into to check
> out what's happening here?
See Merge Replication|||Are you telling me that Transaction replication only works one way?
Gav
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
> > I want this to work both ways but it doesn't seem to be replicating
> > from server B to A. Does anybody know what I can look into to check
> > out what's happening here?
> See Merge Replication|||Unless you use "with updating subscribers", modifications will only be applied one-way. From
publisher -> subscriber. You can make sure that each site only update its own subset of data and let
both be subscribers and subscribers, but be very careful...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gav" <spam@.spam.com> wrote in message news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> > I want this to work both ways but it doesn't seem to be replicating
>> > from server B to A. Does anybody know what I can look into to check
>> > out what's happening here?
>> See Merge Replication
>|||Sorry you have lost me a little bit there... I did say I havn't got much
knowledge in this field, do you have any sources of information on what you
have mentioned here?
Thanks for helping
Gav
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> Unless you use "with updating subscribers", modifications will only be
applied one-way. From
> publisher -> subscriber. You can make sure that each site only update its
own subset of data and let
> both be subscribers and subscribers, but be very careful...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gav" <spam@.spam.com> wrote in message
news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
> > Are you telling me that Transaction replication only works one way?
> >
> > Gav
> >
> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> > news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
> >> > I want this to work both ways but it doesn't seem to be replicating
> >> > from server B to A. Does anybody know what I can look into to check
> >> > out what's happening here?
> >>
> >> See Merge Replication
> >
> >
>|||I misprinted the last sentence, should be "both be both subscriber and publisher". I don't know
offhand where to find more info on this, but I'd start looking in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gav" <spam@.spam.com> wrote in message news:OdQCosY%23EHA.3472@.TK2MSFTNGP14.phx.gbl...
> Sorry you have lost me a little bit there... I did say I havn't got much
> knowledge in this field, do you have any sources of information on what you
> have mentioned here?
> Thanks for helping
> Gav
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
>> Unless you use "with updating subscribers", modifications will only be
> applied one-way. From
>> publisher -> subscriber. You can make sure that each site only update its
> own subset of data and let
>> both be subscribers and subscribers, but be very careful...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Gav" <spam@.spam.com> wrote in message
> news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
>> > Are you telling me that Transaction replication only works one way?
>> >
>> > Gav
>> >
>> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
>> > news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> >> > I want this to work both ways but it doesn't seem to be replicating
>> >> > from server B to A. Does anybody know what I can look into to check
>> >> > out what's happening here?
>> >>
>> >> See Merge Replication
>> >
>> >
>>
>|||Try to look at
http://www.microsoft.com/sql/evaluation/features/replication.asp or Search
Books online for Replication. That will give you an initial knowledge about
Replication.
Regards
Steen
Gav wrote:
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> I want this to work both ways but it doesn't seem to be replicating
>> from server B to A. Does anybody know what I can look into to check
>> out what's happening here?
>> See Merge Replication