Conflict Replication
Fri, 8 Aug 2008 08:08:01 -0700
Hi,
We have a merge replication between our 3 SQL servers at 3 different
locations. 1 is the Publisher and 2 are subscribers. We have PK on a table.
(unique field which is auto incremental by 1) On the Publisher if the user
creates a new order, the table assigns it a number e.g. 1000 in the unique
field (au ...
|
What agent executes sp_adjustpublisheridentityrange?
Thu, 7 Aug 2008 10:56:00 -0700
I am a SQL novice and this is my 1st time using replication. I'm using merge
replication to publish on sever 2005 and pull subscribers using express 2005.
All seemed great, until I could not longer add items to a particular table on
the publisher. It gave an error stating I needed to run
sp_adjustpublisherid ...
|
READ_COMMITTED_SNAPSHOT setting / replication errors?
Wed, 6 Aug 2008 11:28:27 -0700 (PDT)
We have 2 databases ( publisher / subscriber ) participating in a
transactional replication arrangement ( 1-way ).
It's been (probably) months since we have had to fix a problem by
reinitializing a subscription between the two.
Last night, ( in an effort to reduce deadlocks ) we applied the
READ_COMMITTED_S ...
|
The initial snapshot for publication '' is not yet available
Wed, 6 Aug 2008 09:56:01 -0700
SQL 2005 - SP1
We had a server reboot last night and now my replication-monitor with message
'The initial snapshot for publication '' is not yet available on
Distributor-Subscriber tab and is NOT replicating to subscriber.
Upon debugging I found, my snapshot folder is deleted by some process.
I am not sure ...
|
replication agent has not logged a progress message in 10 minutes
Tue, 05 Aug 2008 07:46:47 -0700
SQL 2005 on windows 2003
Staring on Friday, the purblisher started receiving this error to one
subscriber (the other subscriber is fine).
"replication agent has not logged a progress message in 10 minutes"
I have changed the agent profile to Slow Link Agent, but that has made
no difference. THe replicat ...
|
Delete actions Replication
Mon, 04 Aug 2008 20:10:35 GMT
Is there anyway to stop delete transaction from being replicated to the
replicated server. Using SQl Server 2005 transactional replication
--
Message posted via http://www.sqlmonster.com
...
|
Is partitioned replication correct???
Mon, 4 Aug 2008 12:04:28 -0700 (PDT)
Configruation:
Main SQL Server - SQL 2005
Remote SQL Servers SQL 2000 & 2005
I am looking to setup a partitioned transactional publication from my
main SQL Server to all my locations. The remote server names/SQL
Instances all have the location number in their name Location05Server
or R33S-Server.
So wha ...
|
|
|
replication agent has not logged a progress message in 10 minutes
Sun, 03 Aug 2008 21:32:24 -0700
SQL 2005 on windows 2003
Staring on Friday, the purblisher started receiving this error to one
subscriber (the other subscriber is fine).
I have changed the agent profile to Slow Link Agent, but that has made
no difference. THe replication monitor stays on "connecting to
subscriber subscriber1" and doesn't ...
|
Certification in Mind???
Sun, 3 Aug 2008 11:48:08 -0700 (PDT)
Hi All,
Certification in Mind???
Visit www.itjobguru.com for Latest Material.
Regards,
Naveen ...
|
Rename A Subcriber
Fri, 1 Aug 2008 17:33:00 -0700
I already posted a related-connectity question in the connectivity forum, but
I want to see if a workaround is possible. I need to change the name of a
subscriber from "servername" to "servername,portnumber". Is there a way to
do this easily? Or will I be forced to drop the current subscription, and
re-cr ...
|
