Replication methods

Hi,

I'm a newbee to replication and wanted to know about the whole mechanism of replication and how is two way replication implemnted on 2 diffrent servers located at 2 different remote locations?

Replication is a huge subject, but it depends on what your requirements are.

Can data be entered at both locations, and do you want data sent both directions? If so, you want Merge replication.

I think that before we give you an educated answer, you need to provide us with a few more requirements of what you are trying to accomplish. The reason I say this is becuase a blanket statement like "how does replication work" would take volumes to answer. I'm not trying to be rude, just trying to get a little more information so we can best answer your question, only because there are so many aspects and types of replication.

However, it is certainly possible to implement replication with 2 different servers located at 2 different remote locations. It just depends on how you want it implemented and your data requirements.

|||Basically triggers fire and write enteries in tracking tables which refer to the row and table which was updated.

When the merge agent runs it consults these tables to determine what changed on the subcriber since the last time it ran. It then uploads this list to the publisher and processes the deletes first. It compares the changes which have occured on the publisher and subscriber and if any of them have occured on the same row, this row is marked as a conflict and the conflict resolution mechanims kicks in.

Then the merge agent begins to fill in changes which have occured on the publisher to the subscriber and vice versa.

Replication Message

Does anyone know what causes this message?
The row was inserted at 'CVTDEESQL005.ZenithSQL_L_060104' but could not be
inserted at 'ICK24BQZ0J.Zenith'. Procedure or function sp_MSsetrowmetadata
has too many arguments specified.
Our conflict log seems to be full of them
Does this apply?
http://support.microsoft.com/kb/319258/en-us
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
"Spike" <Spike@.discussions.microsoft.com> wrote in message
news:582616D9-62FB-4E73-A83F-01B3C835BBB6@.microsoft.com...
> Does anyone know what causes this message?
> The row was inserted at 'CVTDEESQL005.ZenithSQL_L_060104' but could not be
> inserted at 'ICK24BQZ0J.Zenith'. Procedure or function sp_MSsetrowmetadata
> has too many arguments specified.
> Our conflict log seems to be full of them
>
|||Hi Hilary, I don't think so as we do have service pack 3 applied. However,
it seems to be tied up with a new subscription database that we issued to the
users.
My main concern is to not lose any of changes that have been stored as
conflicts.
kind regards
Spike
"Hilary Cotter" wrote:

> Does this apply?
> http://support.microsoft.com/kb/319258/en-us
> --
> 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
>
> "Spike" <Spike@.discussions.microsoft.com> wrote in message
> news:582616D9-62FB-4E73-A83F-01B3C835BBB6@.microsoft.com...
>
>
|||Spike,
Check your merge agents in the replication monitor, you may see errors
related to space in the database primary tables. We started coming up with
this error over a year ago and after fighting with MS for a long time they
came back that is was a bug in the merger replication. If you view the
replication conflicts for your published database you will probably find a
lot of them. You should be able to resolve them by either keeping the winning
change or resolving, which ever columb has data in it (the other side should
read somthing about the data was changed at both locations, the update
won/lost.. (sorry can't remember the exact verbage). This should add any lost
data back to your database.
I am not sure what SP (if any) that microsoft added this fix to, they sent
us 2 patches to resolve the issue.
Check your database sizes and make sure they are not approaching the limits.
You may need to allocate more space for the primary tables.
Hope this helps you out.
Gary
"Spike" wrote:
[vbcol=seagreen]
> Hi Hilary, I don't think so as we do have service pack 3 applied. However,
> it seems to be tied up with a new subscription database that we issued to the
> users.
> My main concern is to not lose any of changes that have been stored as
> conflicts.
> kind regards
> Spike
> "Hilary Cotter" wrote:

replication merge not put instantaneous time out

replication type merge
suscription two(a-b)
function suscription (a)
not function suscription (b)
What this is the problem !! Help
error: replication merge not put instantaneous time out
thanks!
Christian,
please can you post up the complete error text from the merge agent, and
also list any distinctions between subscriber a and b.
TIA,
Paul Ibison

Replication merge instance is not find in Performance Viewer

Hi all,
I set the configuration for Merge replication for Subscription on
one database and
I have created the Merge replication for publication on another
machine.
And I updated columns of subscription database table and I find
publication machine database table also updated with subscription
database table, here my problem starts,
My problem is when I run replication for merge transaction, I have to
find instance of the Windows on my machine in Performance Viewer (to
see performance viewer goto control panel ->Administrator->performance
in this select performance counter as SQL Server: Replication merge)
but I am not finding the instance
Please some body help me out.
RasheedI am not exactly sure what you mean here. In performance monitor the
counters are by instance. The option to select an instance or all instances
is grayed out. This is by design.
--
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
<sk.rasheedfarhan@.gmail.com> wrote in message
news:1163512500.562695.183350@.h48g2000cwc.googlegroups.com...
> Hi all,
> I set the configuration for Merge replication for Subscription on
> one database and
> I have created the Merge replication for publication on another
> machine.
> And I updated columns of subscription database table and I find
> publication machine database table also updated with subscription
> database table, here my problem starts,
> My problem is when I run replication for merge transaction, I have to
> find instance of the Windows on my machine in Performance Viewer (to
> see performance viewer goto control panel ->Administrator->performance
> in this select performance counter as SQL Server: Replication merge)
> but I am not finding the instance
> Please some body help me out.
> Rasheed
>|||thanks for resopnse Mrs. Hilary cotter
I will explain......i am using SQL Server 2000, when I run replication
(it may be transaction or merge replication) windows components will
run internally.
1) when I was running replication transaction I can see instances in
Performance
viewer but
2) when I was running replication merge I cant see instances in
Performance
viewer
so my doubt is for replication merge can we have the Instance or not ?

Replication merge instance is not find in Performance Viewer

Hi all,
I set the configuration for Merge replication for Subscription on
one database and
I have created the Merge replication for publication on another
machine.
And I updated columns of subscription database table and I find
publication machine database table also updated with subscription
database table, here my problem starts,
My problem is when I run replication for merge transaction, I have to
find instance of the Windows on my machine in Performance Viewer (to
see performance viewer goto control panel ->Administrator->performance
in this select performance counter as SQL Server: Replication merge)
but I am not finding the instance
Please some body help me out.
Rasheed
I am not exactly sure what you mean here. In performance monitor the
counters are by instance. The option to select an instance or all instances
is grayed out. This is by design.
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
<sk.rasheedfarhan@.gmail.com> wrote in message
news:1163512500.562695.183350@.h48g2000cwc.googlegr oups.com...
> Hi all,
> I set the configuration for Merge replication for Subscription on
> one database and
> I have created the Merge replication for publication on another
> machine.
> And I updated columns of subscription database table and I find
> publication machine database table also updated with subscription
> database table, here my problem starts,
> My problem is when I run replication for merge transaction, I have to
> find instance of the Windows on my machine in Performance Viewer (to
> see performance viewer goto control panel ->Administrator->performance
> in this select performance counter as SQL Server: Replication merge)
> but I am not finding the instance
> Please some body help me out.
> Rasheed
>
|||thanks for resopnse Mrs. Hilary cotter
I will explain......i am using SQL Server 2000, when I run replication
(it may be transaction or merge replication) windows components will
run internally.
1) when I was running replication transaction I can see instances in
Performance
viewer but
2) when I was running replication merge I cant see instances in
Performance
viewer
so my doubt is for replication merge can we have the Instance or not ?

Replication merge instance is not find in Performance Viewer

Hi all,
I set the configuration for Merge replication for Subscription on
one database and
I have created the Merge replication for publication on another
machine.
And I updated columns of subscription database table and I find
publication machine database table also updated with subscription
database table, here my problem starts,
My problem is when I run replication for merge transaction, I have to
find instance of the Windows on my machine in Performance Viewer (to
see performance viewer goto control panel ->Administrator->performance
in this select performance counter as SQL Server: Replication merge)
but I am not finding the instance
Please some body help me out.
RasheedI am not exactly sure what you mean here. In performance monitor the
counters are by instance. The option to select an instance or all instances
is grayed out. This is by design.
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
<sk.rasheedfarhan@.gmail.com> wrote in message
news:1163512500.562695.183350@.h48g2000cwc.googlegroups.com...
> Hi all,
> I set the configuration for Merge replication for Subscription on
> one database and
> I have created the Merge replication for publication on another
> machine.
> And I updated columns of subscription database table and I find
> publication machine database table also updated with subscription
> database table, here my problem starts,
> My problem is when I run replication for merge transaction, I have to
> find instance of the Windows on my machine in Performance Viewer (to
> see performance viewer goto control panel ->Administrator->performance
> in this select performance counter as SQL Server: Replication merge)
> but I am not finding the instance
> Please some body help me out.
> Rasheed
>|||thanks for resopnse Mrs. Hilary cotter
I will explain......i am using SQL Server 2000, when I run replication
(it may be transaction or merge replication) windows components will
run internally.
1) when I was running replication transaction I can see instances in
Performance
viewer but
2) when I was running replication merge I cant see instances in
Performance
viewer
so my doubt is for replication merge can we have the Instance or not ?

Replication Merge and Web Service

Hi,
how can I make it work the following procedure:
http://support.microsoft.com/default...b;en-us;319646
in a Web Service? Namely, the previous procedure should become a web
service... I have already tried to create a web service and copy almost all
the code... but after having referenced it as a web reference and then
colling the service, I got the following error:
An unhandled exception of type 'System.Web.Services.Protocols.SoapException'
occurred in system.web.services.dll
Additional information: System.Web.Services.Protocols.SoapException: Server
was unable to process request. -->
System.Runtime.InteropServices.COMException (0x80040E08): The process could
not connect to Distributor 'MYSQLSERVER'.
at SQLMERGXLib.SQLMergeClass.Initialize()
at tAIMx.Services.tAIMx_ReplicationServices.Merge(Str ing strPublisher,
String strDistributor, String strSubscriber, String strPublication, String
strPublisherDatabase, String strSubscriberDatabase) in
c:\inetpub\wwwroot\myservices\replicationservices. asmx.cs:line 97
-- End of inner exception stack trace --
If I run the code without copying it in a web service, it works very well!!
Please help me.
how are you connecting to your distributor? You might want to try using sql
authentication as this seems to be a authentication problem.
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
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:BD0D9A31-8E50-465A-BC8B-90D0223306F2@.microsoft.com...
> Hi,
> how can I make it work the following procedure:
> http://support.microsoft.com/default...b;en-us;319646
> in a Web Service? Namely, the previous procedure should become a web
> service... I have already tried to create a web service and copy almost
all
> the code... but after having referenced it as a web reference and then
> colling the service, I got the following error:
> An unhandled exception of type
'System.Web.Services.Protocols.SoapException'
> occurred in system.web.services.dll
> Additional information: System.Web.Services.Protocols.SoapException:
Server
> was unable to process request. -->
> System.Runtime.InteropServices.COMException (0x80040E08): The process
could
> not connect to Distributor 'MYSQLSERVER'.
> at SQLMERGXLib.SQLMergeClass.Initialize()
> at tAIMx.Services.tAIMx_ReplicationServices.Merge(Str ing strPublisher,
> String strDistributor, String strSubscriber, String strPublication, String
> strPublisherDatabase, String strSubscriberDatabase) in
> c:\inetpub\wwwroot\myservices\replicationservices. asmx.cs:line 97
> -- End of inner exception stack trace --
> If I run the code without copying it in a web service, it works very
well!!
> Please help me.
|||Hi Hilary,
thank you: I've used an NT_Authentication as you can see from the code...
I've discovered that if I run the code (.exe) as an administrator user, it
works, but under another user, it doesn't work. I don't know how to force the
user under who the code should run... can you help me again?
"Hilary Cotter" wrote:

> how are you connecting to your distributor? You might want to try using sql
> authentication as this seems to be a authentication problem.
> --
> 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
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:BD0D9A31-8E50-465A-BC8B-90D0223306F2@.microsoft.com...
> all
> 'System.Web.Services.Protocols.SoapException'
> Server
> could
> well!!
>
>
|||is this user in the PAL?
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
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:DF5EEA36-9B95-4D13-AF5F-02CE6BD141BB@.microsoft.com...
> Hi Hilary,
> thank you: I've used an NT_Authentication as you can see from the code...
> I've discovered that if I run the code (.exe) as an administrator user, it
> works, but under another user, it doesn't work. I don't know how to force
the[vbcol=seagreen]
> user under who the code should run... can you help me again?
>
> "Hilary Cotter" wrote:
sql[vbcol=seagreen]
almost[vbcol=seagreen]
then[vbcol=seagreen]
strPublisher,[vbcol=seagreen]
String[vbcol=seagreen]
|||What is the PAL?
"Hilary Cotter" wrote:

> is this user in the PAL?
> --
> 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
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:DF5EEA36-9B95-4D13-AF5F-02CE6BD141BB@.microsoft.com...
> the
> sql
> almost
> then
> strPublisher,
> String
>
>
|||Your Publication Access List. This is a list of accounts which can pull
subscriptions.
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
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:C39C0E46-E0AA-483B-BF8A-31E0127AA2B5@.microsoft.com...[vbcol=seagreen]
> What is the PAL?
> "Hilary Cotter" wrote:
code...[vbcol=seagreen]
user, it[vbcol=seagreen]
force[vbcol=seagreen]
using[vbcol=seagreen]
web[vbcol=seagreen]
System.Web.Services.Protocols.SoapException:[vbcol=seagreen]
process[vbcol=seagreen]
strPublication,[vbcol=seagreen]
very[vbcol=seagreen]
|||Thank you Hilary,
you gave me an idea how to find the problem which was the permission on the
replicated database: the user, under which the code runs, must have the owner
role of the database... now it works very well.
"Hilary Cotter" wrote:

> Your Publication Access List. This is a list of accounts which can pull
> subscriptions.
> --
> 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
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:C39C0E46-E0AA-483B-BF8A-31E0127AA2B5@.microsoft.com...
> code...
> user, it
> force
> using
> web
> System.Web.Services.Protocols.SoapException:
> process
> strPublication,
> very
>
>