Replication

Snapshot agent won't start
I have set up a publication but can't get the snapshot agent to start. I get the message: The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed. There is no usable information at the suggersted locations. I believe a ... 15 Dec 2009 22:15

Recovery Model for the Distribution Database
It's been a heated discussion in the office now whether our Distribution database should be on FULL or SIMPLE (default) recovery model, and I hope anyone of you could shed some light. Our infrastructure is composed of four (4) P2P sites, each one located in a different geographical area. We are using SQL 2005... 14 Dec 2009 15:28

Web replication
Hello, I need a reference to basic information (white paper) on SQL web replication. Also, is this feature available in SQL 2000? Regards Yba ... 16 Dec 2009 09:02

SQL replication/indexes- 2005 Publisher, 2000 Subscribers
We have a production hotel reservation system database in SQL2005, and we publish a table subset (mainly price and room availability) to several SQL2000 subscriber databases via transactional replication. These subscriber servers are the back-end for our our customer hotel search API. We replicate clustered and non... 12 Dec 2009 16:45

Replication broken, need to delete records from replication. Help.
ultra short version: I need a way to delete a particular command (in the system tables) that's not applying correctly. Long version: I added a table to replication while there was a DDL trigger on the database. That trigger did not deal well with the particular ARITHABORT options, and choked while trying to add... 7 Dec 2009 14:01

Howto find the Name of Logreader and Distribution Task
Hi NG, MSSQL2k8 Transactional Replication How can I find with T-SQL for a known publication the name or ID of the related task for logreader-task, snapshot-task and distribution task, if the task was manually renamed. Thanks in advanced. Thomas ... 24 Nov 2009 11:08

I would like a replication that not expired
I have performed a transactional replication in my company. However, all subscribers are not always connected to the editor/publisher. I have this error: NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074). I know that is related to the Maximum Retention period o... 21 Nov 2009 11:26

Transactional Replication (with Update) problem
Hi, I wanna to work on my project with Transactional (with Update) Replication in distribute offices, it works fine. But I found if the Publisher (same Mechine I use as Distributer) is shut down, or the network connection between Subscriber is disconnected, I can not processing any data update(or delete) in ... 21 Nov 2009 11:26

Merge Replication Question
Hi, I am configuring Merge replication for one of our new critical project..This project has requirment to have servers on multiple locations..Here is the basic architecture of replication setup.. Node A -- Publisher Node B -- Subscriber 1 Node C -- Subscriber 2 Node D -- Subscriber 3 So I have few questi... 21 Nov 2009 10:19

merge replication snapshot problem
Saddenly during generation of merge snapshot I get this error The process could not create file '\\Srvproduction\REPLDATA\unc\SRVPRODUCTION_nara97be_Puna replika\20091111162118\MSmerge_contents.bcp'. All file in snapshot is generated in folder including msmerge_content_xxxx for each article but after this error all i... 11 Nov 2009 13:29