Any thoughts on how to replace a distribution server without starting all publications from scratch? The basic situation is that we have a lot of large publications (some require 10 hour snapshots) using a distribution server which has some hardware problems & my VP wants to replace the entire...more >>

I have set up a merge replication between two servers using a VPN over the internet. When I use a broadband connection (1 Mbps) everything works just fine. However, when I use a modem connection onto the internet (44 Kbps) I get a timeout error from the agent How do I reconfigure the agent to le...more >>

DEAR FRIENDS I AM GETTING THE FOLLOWING ERRORS. PLS HEL LAST COMMAND create table #belong_agent_-274995906 (tablenick int NOT NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage varbinary(255) NULL, colv varbinary(2048) NULL ERROR MESSAGE : Failed to enumerate changes in the...more >>

I have a snapshot replication between sqlserver 2k and sybase,the replication include serveral tables,my questions is: when replication happens,did sqlserver drop all tables included in the replication and rebuilt the tables and datas in sybase all at same time ,or delete one table and the ro...more >>

Hello My appologies if this gets posted twice...I tried to post earlier but it didn't seem to work.. I'm a newbie to replication and was wondering if someone could help. I've noticed that a job named 'Distribution clean up: distribution' (i believe this was created automatically when replication...more >>

Hi, We deployed our app to a client, by this scenario: a publication with 11 subscribers, with merge replication. The client's dba made a major mistake and restored a local database over the distribution database. He has no backup of the distribution. Is there anything that can be done to ...more >>

I am trying to synchronize a pull subscription via diap-up where the logged in user is not a member of sys admin or db_owner. I get an error saying that the user must be a member of these roles. How can I override this. Basically, I want to give everyone in the Public role permission to...more >>

All I need to add one table into my existing replication process. I can use the GUI to include the new table into the existing publisher. However, the replication only works for the original tables. No replication is happening on the newly added table What can I do to make replication working on t...more >>

Where can I get information about configure a replication from SQL server CE to SQL server 2000?....more >>

Hi Folks, I was wondering if a Read Only Database can also be a publisher. Keep in mind that this Read Only Database is a standby server for Log Shipping. Thanks. ...more >>

Yesterday an upgrade was done on a third party database. I have various replications from this database to other databases that I have created (eg Action table). I was worried that the upgrade would "damage" the replications, but they continued to work fine. However the Action table in my dat...more >>

Hallo, I have to set up replication on an sql-server and on serveral clients (laptops) - (in German) Mergereplikation. Before I do that I need to know what happens, if the client deletes a row. After the replication I would expect that row to be deleted on the server database as well. Is that ...more >>

When I restart the distribution agent for some reasons (e.g. rebooting the machine) it fails to start properly generating errors "Unable to insert duplicate records..." To clarify the setup: We have Publisher (A) and Distributor-Subscriber (B). The publication is transactional not distribut...more >>

Hi ! I try to make a merge replication over internet - Publication Computer Name : T02 (Windows 2000, SQL Server 2000) - Subscriber Computer Name : SERVEUR2000 (Windows 2000, SQL Server 2000) accessed by PROSME.DYNDNS.ORG Snapshort replication work successfuly but Merge Agent run ocur error...more >>

I am trying to change from a Merge Pull subscription model to a Merge Push model. I have a filter on several articles so only data intended for a particular subscriber is sent to it. This is done like so: @subset_filterclause = N'Upper(TableName.TerminalID) = Upper(Host_Name())' . When I tested the ...more >>

Hello. Sorry to be re-posting something, but there were no takers a few weeks ago, and maybe I asked it wrong or someone else is out there now... Here's what I'm up against. I'm new to tsql and Querry Analyzer (as an old applications guy in a new Microsoft world). Our cancer research c...more >>

Dear all Simple quick question hopefully. Do the snapshot and publication agents have to run via a schedule or can we set them to run as soon as there has been a change and remain idle the rest of the time. Wing ...more >>

QUick check - when people talk about FTP and replication, is this just for initialisation - ie distributing the snapshot? I can't see how merge or transactional (merge/distribution agents) can work over FTP, but I just wanted to check Regards John...more >>

Is there any purpose in having more than one distribution database - eg can you specify which publication uses which database. If this is possible it simplifies the transactional backup strategy when more than one publication uses the same distributer Thanks Joh ...more >>

I'm using the following process to make schema changes to replicated databases (transactional replication, local distributor, push subscription, sql2000): 1. drop the subscription to the table 2. drop the article so we can make changes to it 3. make schema changes 4. recreate the article...more >>

Snapshot fails to be applied. I am testing Replication on an XP laptop PC, which is not a Windows Server My first concern and question: is it a requirement that replication b accomplished only on a Windows Server PC? My test PC is not a Windows Server. But, I am running SQLServer2000 on it. ...more >>

I am doing transactional replication with updatable subscriptions and I need to know what order to upgrade my servers I have the publisher on one server and am doing remote distribution (pull subscriptions), so the distributor and the subscriber are both on the second server. I have been told to u...more >>

I am currently an MCP in SQL Server Admin. but have little experience with replication. Can anyone recommend any good books on SQL Server replication?...more >>

Hi Ther I have an MS Access 2002 ADP using MSDE, which will be running on various laptops I need a way to programmatically fire of the replication to a backend SQL server rather than use 'syncronise' Any ideas appreciated? I keep hearing about teh ActiveX controls for this kinda thing but can't f...more >>