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...
> 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...
>
|||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...
>
|||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...
> applied one-way. From
> own subset of data and let
> news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
>
|||Try to look at
http://www.microsoft.com/sql/evaluat...eplication.asp or Search
Books online for Replication. That will give you an initial knowledge about
Replication.
Regards
Steen
Gav wrote:[vbcol=seagreen]
> 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...