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 >>

I created a new table in the database and used the sp_addarticle to add the table to the SQL Server 2000 transactional replication. Next I reinitialize the subscription and received the following error. This help resolve this error. Thank You, Dan Violation of PRIMARY KEY con...more >>

I have Main server as Publisher "MSER", 2 other server as subsriber "SUBSER1","SUBSER2", I want to add another server "NEWSER" as subscriber but the data must came from SUBSER2 using the same database. NEWSER is a subscriber in SUBSER2, SUBSER2 is subscriber in MSER. can that be done? if yes i...more >>

I have transactional replication between two 2000 sql servers. An it is working great during the day. Working hours for that company are from 10 am. to 8 pm. And then every morning with the first transaction that need to be replicated I got: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGO...more >>

Hi, i want ask, if someone knows some good books for getting information about replication and also links to websides. ...more >>

What order should I upgrade my SQL2000 servers if I am running a publisher on one server and a remote distributor and a subscriber on the second server?...more >>

Hello All As part of our company standards, we cannot use SQL Mail utility, provided as part of Microsoft SQL Server, for generating alerts. We use a third party tool that monitors PerfMon and generate alerts if some thresholds are set. Now, I set User Counters (using sp_user_counter[1..10]) to se...more >>

Hi I am getting the following error message whilst implementing a master-slave snapshot replication: Creating the DTS package for replication Sql server enterprise Manager could not complete this operation. ...more >>

Hi All I have two sql servers hold identical databases, and one database table contains a field of type varchar(7500), this field being used by users to enter some comments. Now both the servers contains the same records, but only in one server, the above mentioned field contains values for comment...more >>

hi, i'm trying to use Merge publication for replicating as it suits me better than any other. but when i do that it addresses some issues that seem to be changing my database tables. like it tells me that 'uniqueidentifier' column will be added to tables. and three others as well. i'm pretty mu...more >>

Hi everyone, I think I have got myself into deeper trouble than I know how to get out of ... so Help! :) I have been trying to set up replication on an existing machine. I have set up replication before and I have had no problems. I have done something during configuring the publication t...more >>

I posted a message a few days ago but the list that I download seems to have been truncated and my message has disappeared! Any ideas? ...more >>

I am trying to get log shipping working. Below are the details: 1. 2 servers (1 on w2k, the other on XP) 2. They are in the same domain 3. created identical userid/passwd ( on local mc on both servers) 4. SQL Server and Agent run using this created userid/password on both servers 5. Created ma...more >>

Hi all. I'd like to set up a replication using a MySql database as a subscription server. Is it possible? Reading BOL, it seems that is it possible to use a ODBC/OleDB data base, but it has to support transaction. Any suggestion will be appreciated. Thanks Ruggero PS: excuse my poor en...more >>

I am replicating a database that was created by another group. There are conditions where it is acting as if when a new record is created, the record comes across, but when the blob is updated, it is not being sent across. If I go in an manually change the record (some other field), the change co...more >>

Hi everyone, Is there any way I can increase the performance of a snapshot? I'm currently running sql2k sp3 and win2k sp4 with merge replication running between two servers at different locations (about 15 mi. apart). My database is over 200GB in size. My snapshots are taking longer and ...more >>

Hi, I have a merge push replication between 2 MSSQL 2000 servers. During the past 5 months I've experienced 2 instances of a strange problem. The Merge agent jobs disapears! There is no error message of any kind. The only thing I can do is to set up the replication from scratch again. Why? Am ...more >>

Currently I have two SQL boxes in different locations using a VPN tunnel both are on different networks and different AD's. The VPN is setup correctly with ANY/ANY passing traffic between the two just fine 130.1.1.23 = North (Named=SBWEBSQLSVR 192.168.1.150 = South (Named=SQL01OCSBT I can do a ...more >>

I am looking for a way to create a daily mirror copy of a SQL server 2000 database. I am not really familiar with replication at all... Thank you in advance, Mohamed...more >>

Hi there, I have a database called Db1 that subscribes to a main, database, MainDb, through a publication. The articles on this publication allow Interactive Conflict Resolution. When a conflict happens between Db1 and MainDb, the conflict resolver interface comes up and I'm able to r...more >>

I would like to add table to the publisher and the subscriber database that uses transactional replication. I applied the add_article with @article, @Source_Table, and @Destination_table. The table was added to the article but the schema or data was not added to the subscriber. What do...more >>

I've encountered a baffling syntax error when installing Replication and greatly appreciate your help. After installing replication on a new Windows 2000 server the Log Reader Agent displays the error "Line 22: Incorrect Syntax near '='. The step failed". When I manually run the log...more >>

I would like to create a new index on my table that is replicated in the Publisher atricle. What is the correct procedure to create an index on the Publisher database and then have the subscriber have the same index. Thank You, Dean ...more >>

Greetings, I am hoping someone can help and lead me in the correct direction on a situation my company's facing. We run and support MSSQL 2000. We have a project that requires access to data that is being collected from all over the US, but this data is all collected in an Oracle da...more >>

Dear Friends I am getting following error. You must rerun snapshot because current snapshot files are obsolete. (Source: Merge Replication Provider (Agent); Error number: -2147201021) Please suggest how i can solve the problem. Your earlier reply will be helpful. Best regards S...more >>

I've got a merge publication set up with dynamic filters. Every now and then, we run some data maintenance jobs that end up creating a lot of records in the MSMerge_contents and MSMerge_tombstone tables. After these jobs are run, the synchronization process starts slowing down dramatically. ...more >>

Hi, I have a replicated copy of a database on one server and the full database on another. The stored procedures are missing on the replicated copy. How to proceed to get them in? Thanks. Sam...more >>