I am new to replication and have setup Merge replication (SQL2k) to synch
with laptops. I made some data changes on the Publisher and then synched
with the laptop and it got the new data. Then, I added a test table and 2
rows of data on the Publisher. After a few minutes I tried to synch again
and did not get the table changes. Is there something I have to do with the
Snapshot Agent in order to make that new table and data get to the laptop?
Thanks.
David
David - you'll need to run the snapshot agent then the merge agent to have
this new table included.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Is there a way that I can do this with system stored procedure? if so,
do you know what they are? e.g. sp_?
Thanks.
David
*** Sent via Developersdex http://www.codecomments.com ***
|||David - sp_start_job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Boy, when I create Microsoft Access replication it just automatically
grabbed the new table and data without me doing anything. I guess SQL
Server takes more work?
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Paul,
How do I run the Merge Agent manually? Can I do it in EM? I was able to
run the Snapshot Agent but I do not see where I can run the Merge Agent.
Can you help?
p.s. The same server is both publisher and Distributor, if that helps.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Interesting - I never knew Access did this. I'm not too sure that this is
ideal though. If you added a completely unrelated and large table it would
be a pain if it was automatically added.
Cheers,
Paul
"David" <dlchase@.lifetimeinc.com> wrote in message
news:OdjxfH2$FHA.3136@.TK2MSFTNGP15.phx.gbl...
> Boy, when I create Microsoft Access replication it just automatically
> grabbed the new table and data without me doing anything. I guess SQL
> Server takes more work?
> David
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
>
|||David,
you should see the merge agent when you expand the replication monitor. If
the subscription is pull, then just run the job on the subscriber (merge
agent is synonomous with a job that runs merge.exe).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Use the conflict viewer to determine if these changes were conflicts and
were rolled back.
Also are you using any filtering? It is possible that these changes where
filtered out by the filter.
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
"David" <dlchase@.lifetimeinc.com> wrote in message
news:%23%23JQ5N0$FHA.4012@.TK2MSFTNGP10.phx.gbl...
>I am new to replication and have setup Merge replication (SQL2k) to synch
>with laptops. I made some data changes on the Publisher and then synched
>with the laptop and it got the new data. Then, I added a test table and 2
>rows of data on the Publisher. After a few minutes I tried to synch again
>and did not get the table changes. Is there something I have to do with
>the Snapshot Agent in order to make that new table and data get to the
>laptop? Thanks.
> David
>
|||I see that in Replication Monitor but it has a red X on the folder and also
on the Publishers folder. I don't know where to look for why the red X is
there. Also, ALL subscribers will be anonymous as they are laptops that
will be disconnected from the network from time to time. Did I do anything
wrong? This is my first (test) laptop and I want to get this right before
deploying into production.
p.s. Data changes are replicating, but the new table is still not getting to
the anonymous subscriber. Also, I tried running the start from the merge
agents folder and it prompted me for a username and password for the laptop
database.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OUkYiy2$FHA.2652@.TK2MSFTNGP09.phx.gbl...
> David,
> you should see the merge agent when you expand the replication monitor. If
> the subscription is pull, then just run the job on the subscriber (merge
> agent is synonomous with a job that runs merge.exe).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Showing posts with label sql2k. Show all posts
Showing posts with label sql2k. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
merge replication problem
hi all,
i have a merge replication setup with sql2k sp3 and msde clients.
all works great except, I can see that some changes are not accepted
through replication - the text reverts back to its original text !
I'm not sure what this could be - have tried changing the value manually
on the publisher/ditributor but a few minutes later its back to the
original text!
any help would be appreciated !
tia.
Ranjeet.
check the conflict viewer. YOu are likely to find the problem there.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsdnndrdav8so89@.athwalrt40.castlewood.co.uk. ..
> hi all,
> i have a merge replication setup with sql2k sp3 and msde clients.
> all works great except, I can see that some changes are not accepted
> through replication - the text reverts back to its original text !
> I'm not sure what this could be - have tried changing the value manually
> on the publisher/ditributor but a few minutes later its back to the
> original text!
> any help would be appreciated !
> tia.
> Ranjeet.
|||Thanks for your help (Hillary and Paul)
I can't see any conflicts in the conflict viewer at the moment - however,
I did recently resolve one that relates to the same table.
I will try the fix provided by microsoft as soon as I can get a copy of
the patch.
thanks.
On Wed, 1 Sep 2004 08:57:10 -0700, Paul Ibison <Paul.Ibison@.Pygmalion.Com>
wrote:
> Ranjeet,
> can you check to see if there are any conflicts in the
> please conflict viewer.
> Also, this may be called the "compensate_for_errors"
> problem. If a change from publisher fails to get applied
> at the subscriber (for some reason, PK,FK,CHECK,etc
> constraints) it undoes the change at the publisher. So a
> insert from publisher when fails at the subscriber gets
> deleted at the publisher too. Similary a delete from
> publisher which fails at the subscriber, it gets re-
> inserted at the publisher. Have a look at
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;828637&Product=sql2k to see if it applies.
> HTH,
> Paul Ibison
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
sql
i have a merge replication setup with sql2k sp3 and msde clients.
all works great except, I can see that some changes are not accepted
through replication - the text reverts back to its original text !
I'm not sure what this could be - have tried changing the value manually
on the publisher/ditributor but a few minutes later its back to the
original text!
any help would be appreciated !
tia.
Ranjeet.
check the conflict viewer. YOu are likely to find the problem there.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsdnndrdav8so89@.athwalrt40.castlewood.co.uk. ..
> hi all,
> i have a merge replication setup with sql2k sp3 and msde clients.
> all works great except, I can see that some changes are not accepted
> through replication - the text reverts back to its original text !
> I'm not sure what this could be - have tried changing the value manually
> on the publisher/ditributor but a few minutes later its back to the
> original text!
> any help would be appreciated !
> tia.
> Ranjeet.
|||Thanks for your help (Hillary and Paul)
I can't see any conflicts in the conflict viewer at the moment - however,
I did recently resolve one that relates to the same table.
I will try the fix provided by microsoft as soon as I can get a copy of
the patch.
thanks.
On Wed, 1 Sep 2004 08:57:10 -0700, Paul Ibison <Paul.Ibison@.Pygmalion.Com>
wrote:
> Ranjeet,
> can you check to see if there are any conflicts in the
> please conflict viewer.
> Also, this may be called the "compensate_for_errors"
> problem. If a change from publisher fails to get applied
> at the subscriber (for some reason, PK,FK,CHECK,etc
> constraints) it undoes the change at the publisher. So a
> insert from publisher when fails at the subscriber gets
> deleted at the publisher too. Similary a delete from
> publisher which fails at the subscriber, it gets re-
> inserted at the publisher. Have a look at
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;828637&Product=sql2k to see if it applies.
> HTH,
> Paul Ibison
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
sql
Monday, March 12, 2012
Merge replication latency
I'm a newby to SQL Server and by default is responsible for my company SQL
servers. We've a merge replication environement for 2 SQL2K databases. I
would like to know if there's a way to find and monitor the latency
frequency in this merge replication environment?
I found this great article that shows how to track latency for a
transactional replication environment.
http://databasejournal.com/features/...le.php/3441801
But have not been succesfull in converting it to a merge environment.
Thanks,
TLN
servers. We've a merge replication environement for 2 SQL2K databases. I
would like to know if there's a way to find and monitor the latency
frequency in this merge replication environment?
I found this great article that shows how to track latency for a
transactional replication environment.
http://databasejournal.com/features/...le.php/3441801
But have not been succesfull in converting it to a merge environment.
Thanks,
TLN
merge replication issue
Hi all,
Setup: SQL2K (Enterprise) [SQLSVR1] in Network 1 - 2 publications (merge
for tables that data changes in often, and snapshot for stuff that is
batched after a few months) - there are a number of MSDE subscribers to
these publications in this network.
The same setup is in Network 2 [SQLSVR2].
SQLSVR2 subscribes to the SQLSVR1 publications, and re-publishes them for
Network 2 MSDE subscribers.
I have an app that works on the local msde installations - any changes to
a specific database is then replicated.
Everything works great in Network 1.
On Network 2, I tried to insert into a specific table and I get a
"Invalid object name 'ctsv_EEF98A7665F64374A3C47E6A3D87155E'." error ?
Other tables do not appear to be effected ?
I read a post that appear to suggest security context in setting up the
publications ? - the publications security context is a sql user, and the
distribution folder is shared so that all users in the network can read
and write to it
(http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg)
Any information on helping me resolve this would be useful.
tia,
Best Regards,
Ranjeet.
how did you deploy the problem subscriber?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsemtjwu6v8so89@.athwalrt40.castlewood.co.uk. ..
> Hi all,
> Setup: SQL2K (Enterprise) [SQLSVR1] in Network 1 - 2 publications (merge
> for tables that data changes in often, and snapshot for stuff that is
> batched after a few months) - there are a number of MSDE subscribers to
> these publications in this network.
> The same setup is in Network 2 [SQLSVR2].
> SQLSVR2 subscribes to the SQLSVR1 publications, and re-publishes them for
> Network 2 MSDE subscribers.
> I have an app that works on the local msde installations - any changes to
> a specific database is then replicated.
> Everything works great in Network 1.
> On Network 2, I tried to insert into a specific table and I get a
> "Invalid object name 'ctsv_EEF98A7665F64374A3C47E6A3D87155E'." error ?
> Other tables do not appear to be effected ?
> I read a post that appear to suggest security context in setting up the
> publications ? - the publications security context is a sql user, and the
> distribution folder is shared so that all users in the network can read
> and write to it
>
(http://groups.google.com/groups?hl=e...32G%23zQRJBHA.
388%40tkmsftngp02&rnum=1&prev=/groups%3Fq%3Dinvalid%2520object%2520name%2520
%27tsvw_%26hl%3Den%26lr%3D%26ie%3DUTF-8%26sa%3DN%26tab%3Dwg)
> Any information on helping me resolve this would be useful.
> tia,
> Best Regards,
> Ranjeet.
|||used enterprise manager logged on as a user in network 1 (registered the
subscriber in EM, and clicked through to add pull subscription to SQLSVR2
in network 2).
the subscriber and publisher were part of network 2.
|||when you start getting messages like this telling you you have missing
views, or the merge agent expects a different view than the one present on
your subscriber, you have inconsistent replication metadata.
While it is entirely possible to hack your way through the triggers and
adjust them for the views the merge agent expects to use, you are better off
to redeploy your subscriber.
I'm still not exactly sure how you deployed your subscribers. The way to do
it is to create a publication on SQLSRV1, and deploy a subscription to
SQLSRV2. After the subscription is deployed to SQLSRV2, you then create
your publication on SQLSRV2 and deploy the subscriptions to the MSDE
subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsem0kgrgv8so89@.athwalrt40.castlewood.co.uk. ..
> used enterprise manager logged on as a user in network 1 (registered the
> subscriber in EM, and clicked through to add pull subscription to SQLSVR2
> in network 2).
> the subscriber and publisher were part of network 2.
|||Hi Hillary,
thanks for the info.
My deployment was as you described.
I am now rebuilding the subscriptions and publications for network 2 and
SQLSVR2 in the hope that this fixes this most frustrating problem. I am
in the fortunate position that my users are not yet ready to go live in
network 2 (phew!).
I will update this post with my results incase it is ever useful to anyone.
thanks again,
Ranjeet.
|||recreating the server subscription and publications resolved this problem.
thanks again for your help hilary.
Ranjeet.
Setup: SQL2K (Enterprise) [SQLSVR1] in Network 1 - 2 publications (merge
for tables that data changes in often, and snapshot for stuff that is
batched after a few months) - there are a number of MSDE subscribers to
these publications in this network.
The same setup is in Network 2 [SQLSVR2].
SQLSVR2 subscribes to the SQLSVR1 publications, and re-publishes them for
Network 2 MSDE subscribers.
I have an app that works on the local msde installations - any changes to
a specific database is then replicated.
Everything works great in Network 1.
On Network 2, I tried to insert into a specific table and I get a
"Invalid object name 'ctsv_EEF98A7665F64374A3C47E6A3D87155E'." error ?
Other tables do not appear to be effected ?
I read a post that appear to suggest security context in setting up the
publications ? - the publications security context is a sql user, and the
distribution folder is shared so that all users in the network can read
and write to it
(http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg)
Any information on helping me resolve this would be useful.
tia,
Best Regards,
Ranjeet.
how did you deploy the problem subscriber?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsemtjwu6v8so89@.athwalrt40.castlewood.co.uk. ..
> Hi all,
> Setup: SQL2K (Enterprise) [SQLSVR1] in Network 1 - 2 publications (merge
> for tables that data changes in often, and snapshot for stuff that is
> batched after a few months) - there are a number of MSDE subscribers to
> these publications in this network.
> The same setup is in Network 2 [SQLSVR2].
> SQLSVR2 subscribes to the SQLSVR1 publications, and re-publishes them for
> Network 2 MSDE subscribers.
> I have an app that works on the local msde installations - any changes to
> a specific database is then replicated.
> Everything works great in Network 1.
> On Network 2, I tried to insert into a specific table and I get a
> "Invalid object name 'ctsv_EEF98A7665F64374A3C47E6A3D87155E'." error ?
> Other tables do not appear to be effected ?
> I read a post that appear to suggest security context in setting up the
> publications ? - the publications security context is a sql user, and the
> distribution folder is shared so that all users in the network can read
> and write to it
>
(http://groups.google.com/groups?hl=e...32G%23zQRJBHA.
388%40tkmsftngp02&rnum=1&prev=/groups%3Fq%3Dinvalid%2520object%2520name%2520
%27tsvw_%26hl%3Den%26lr%3D%26ie%3DUTF-8%26sa%3DN%26tab%3Dwg)
> Any information on helping me resolve this would be useful.
> tia,
> Best Regards,
> Ranjeet.
|||used enterprise manager logged on as a user in network 1 (registered the
subscriber in EM, and clicked through to add pull subscription to SQLSVR2
in network 2).
the subscriber and publisher were part of network 2.
|||when you start getting messages like this telling you you have missing
views, or the merge agent expects a different view than the one present on
your subscriber, you have inconsistent replication metadata.
While it is entirely possible to hack your way through the triggers and
adjust them for the views the merge agent expects to use, you are better off
to redeploy your subscriber.
I'm still not exactly sure how you deployed your subscribers. The way to do
it is to create a publication on SQLSRV1, and deploy a subscription to
SQLSRV2. After the subscription is deployed to SQLSRV2, you then create
your publication on SQLSRV2 and deploy the subscriptions to the MSDE
subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ranjeet" <not-telling> wrote in message
news:opsem0kgrgv8so89@.athwalrt40.castlewood.co.uk. ..
> used enterprise manager logged on as a user in network 1 (registered the
> subscriber in EM, and clicked through to add pull subscription to SQLSVR2
> in network 2).
> the subscriber and publisher were part of network 2.
|||Hi Hillary,
thanks for the info.
My deployment was as you described.
I am now rebuilding the subscriptions and publications for network 2 and
SQLSVR2 in the hope that this fixes this most frustrating problem. I am
in the fortunate position that my users are not yet ready to go live in
network 2 (phew!).
I will update this post with my results incase it is ever useful to anyone.
thanks again,
Ranjeet.
|||recreating the server subscription and publications resolved this problem.
thanks again for your help hilary.
Ranjeet.
Saturday, February 25, 2012
Merge Replication Conflict Notification
SQL2K SP4
Windows 2000 server
Merge Replication
How can I get sql server to log to the windows event long when a conflict occurs so that I can set up a notification alert. I have gone to the replication alerts in enterprise manager and set one up but it is never triggered and there is never anything in the windows event log.If it's not raised that means it was never triggered.
Windows 2000 server
Merge Replication
How can I get sql server to log to the windows event long when a conflict occurs so that I can set up a notification alert. I have gone to the replication alerts in enterprise manager and set one up but it is never triggered and there is never anything in the windows event log.If it's not raised that means it was never triggered.
Monday, February 20, 2012
merge replication and domains
Does SQL2K needs the publisher and subscriber to be in same domain?
Can we configure merge replication between two stand-alone servers?
it does not, you can replicate from two stand alone server. What you should
do is create a local administrator account with the same name and password
on both servers and use this account for the SQL Server and SQL Server Agent
accounts.
--
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
"ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
> Does SQL2K needs the publisher and subscriber to be in same domain?
> Can we configure merge replication between two stand-alone servers?
|||You might want to have a look at these articles:
http://www.replicationanswers.com/InternetArticle.asp
http://support.microsoft.com/?id=321822
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I have done that..but when i create the subscriber i get the message..process
could not deliver the snapshot to the subscriber..
"Hilary Cotter" wrote:
> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>
|||i did that but it was not working. Only after giving the $ share access to
the snapshot folder it started working.
"Hilary Cotter" wrote:
> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>
Can we configure merge replication between two stand-alone servers?
it does not, you can replicate from two stand alone server. What you should
do is create a local administrator account with the same name and password
on both servers and use this account for the SQL Server and SQL Server Agent
accounts.
--
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
"ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
> Does SQL2K needs the publisher and subscriber to be in same domain?
> Can we configure merge replication between two stand-alone servers?
|||You might want to have a look at these articles:
http://www.replicationanswers.com/InternetArticle.asp
http://support.microsoft.com/?id=321822
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I have done that..but when i create the subscriber i get the message..process
could not deliver the snapshot to the subscriber..
"Hilary Cotter" wrote:
> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>
|||i did that but it was not working. Only after giving the $ share access to
the snapshot folder it started working.
"Hilary Cotter" wrote:
> it does not, you can replicate from two stand alone server. What you should
> do is create a local administrator account with the same name and password
> on both servers and use this account for the SQL Server and SQL Server Agent
> accounts.
> --
> --
> 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
> "ravi lobo" <ravi lobo@.discussions.microsoft.com> wrote in message
> news:1E7324F8-3F93-45C3-876A-56A7FE81D907@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)