| Thread | Last Post | Replies |
|
| snapshot not working | 30 Jun 2007 23:50 GMT | 2 |
I'm trying to set up transactional replication using SSMS. I had no errors creating the publisher and distributor but had warnings when the subscription create was running saying that another sa process was running. I'm new to this and do not know how to get the snapshot to run ...
|
| SQL 2005 Log Reader error 18805 | 28 Jun 2007 20:06 GMT | 3 |
Firts we create 12 publication, each with many articles, all initialize and sincronism ok. After that, we just use one aplication to manipulate data at publisher. Twice error 18805 appear. The Log reader can not execute and this message
|
| is replication session a transaction? | 28 Jun 2007 13:49 GMT | 1 |
I am curious if a "session" for merge replication is a transaction. If I see 100 actions in the Agent History and the last one is "the process could not enumerate changes at the subscriber" due to General Network Error (dropped connection or whatever), did those 10000 data ...
|
| automating snapshots | 28 Jun 2007 08:18 GMT | 2 |
I'm new to replication and maybe I'm missing something. I set up replication from one server to another (push). The replication is working fine every hour, but I have to start the snapshots manually.
|
| SQL Agent terminates, then replication can't restart. | 27 Jun 2007 17:32 GMT | 5 |
Our setup is pretty simple, one transactional box, a remote distributor, and a reporting server using one way transactional replication, push subscription, no immediate updating. (All boxes SQL 2005) Around 3am the sql server agent died on the distribution sever with this message ...
|
| How to? | 27 Jun 2007 09:34 GMT | 1 |
Is there a way where I can add a table to an existing publication in SQL 2000 (both publisher and subscriber) and get the transactional replication to work without generating the snapshot of the whole database ? There are few tables who have columns omitted from the existing ...
|
| Replication implementation hurdles. | 27 Jun 2007 09:12 GMT | 2 |
We have a product that configures on SQL 2000 and also configures the replication. We are in the process of doing R&D on SQL 2005. Following are my machine specifications OS Type : Windows 2000 Server (SP4)
|
| Can't copy/export a database with identity *NEWBIE* | 27 Jun 2007 03:44 GMT | 3 |
I have a database where some tables have the IDENTITY = YES. If I copy or export from ServerA to ServerB, the IDENTITY gets set to No. This has to be a simple problem. How is it fixed?
|
| Merge replication error 1326 | 26 Jun 2007 23:04 GMT | 1 |
Does anybody know what could cause this error: The schema script '\\SERVERP\ReplData\unc\SERVERP_ANIL_ANIL \20070626175153\ZEZALOGADATUM_1.sch' could not be propagated to the subscriber.
|
| replication not working | 26 Jun 2007 21:42 GMT | 5 |
I set up a transactional, pull publisher, distributor and subscriber last week on a development system and all worked fine. Then, I did the same set up on our production system and it is not working. When this was started on Thursday night the distributor would not start. I ...
|
| 1 question | 26 Jun 2007 11:20 GMT | 1 |
I am using MCALL for updates sql statement, I know MCALL only replicates the changed columns, however is it possible to force a certain column to be replicated even there are no changes to it? Thanks in advance.
|
| Automate reinitialization | 26 Jun 2007 03:04 GMT | 1 |
Currently, we have many MSDE instances that subscribe to our main server. Morning, we have to re-init whenever there's a failed subscription. Is there a way or script to automate the reinitialization? Also, how can we indicate it to use the current snapshot or generate a new ...
|
| Merge Replication doesn't re-propagate changes coming from transactional replication | 25 Jun 2007 11:45 GMT | 1 |
I have the following setup: OracleDB SQL2005 SQL2005Express
|
| MSREPL_Commands TABLE | 22 Jun 2007 19:03 GMT | 3 |
I don't think I ever resolved this issue & now I am quite concerned about my growing MSRepl_Commands table. It has over 9 million rows. What steps can I take to reduce the number of rows in this table? Thanx!
|
| Merge Replication Agents | 22 Jun 2007 16:52 GMT | 3 |
I have a system of 2 PC, with installed Win XP and SQL 2000. I configured one PC as Publisher and Distrbutor, and the other as a Subscriber with a "push" subscription. The snapshot and the merge agents are running on the Publisher/Distributor. This PC is always ON
|