Hi, I need replication with ACID requirements and changes made to both databases, but it will be done over VPN in production and can sometimes loose connectivity. So I use transactional replication with updatable queued subscriptions. What I cannot understand (and I'm not SQL expert at all...more >>

Hello NG, I need a Replication(Snapshot) from a MS-SQL Server 8 to another MS-SQL Server 8. With the help of the wizard I set everything (origen, destination, publication etc.) up. The replication (seems) to run correctly but my problem is, that the data gets appended on the Subscriber. B...more >>

We used to use pure continuous Transactional Replication to replicate our data with no problems. Due to business requirements change, we need to update data at subscriber occasionally. After the publication and push subscriptions were set up successfully, we can replicate data from publisher t...more >>

I tried Snapshot Replication with SQL Server Enterprise Manager. I find the column of timestamp type become binary type in subscriber database. Why? ...more >>

Hi All I'm currently "Proof of Concept"ing our new server architecture, which is going to contain a Master SQL Server with a Remote Distributor. After ploughing through the initial permission probs, i've hit another problem that i dont know how to get around. If i try to create a Publica...more >>

Let me start with this: We have a critical SQL application on a Win 2003 with SQL 2000 sp3a. I set up another Win 2003 server with SQL 2000 sp3a. From posts read I believe log shipping is what I want, the files can be replicated overnight and appears to be easiest to manage. OK, my questio...more >>

Hi folks! I am wondering if anyone out there has been able to use the NOT FOR REPLICATION field constraint when implementing a manual replication process? From what I have read, only the inbuilt replication methods can actually insert identity fields without SQL Server happily updating it's i...more >>

Any considerations for apply SP4 to SQL server with replication? Thanks in advance, ...more >>

Hi ng, we have serious problem, we administrating one merge replication between Sql 2000 Serwers, we had about 1000 conflicts in ConflictViewer, we wanted to resolve this conflicts in monday, but during the weekend new snapshot was generated and our all conflicts disappeared. now we ...more >>

Hello, We're running transactional replication with no trouble...except we can't seem to change the article defaults. We are running SQL Server 2000, SP3, Standard edition. We don't want data deleted on the subscribers when data is deleted on the publisher. I follow directions in chapter...more >>

ms-SQL2000 sp4 I want to replicate a database to a destination db using transaction replication (one way) This destination db (subscriber) has alredy the schema which is the same as the source (publisher) schema BUT a column is added on each table. (and I don't want to add this column at ...more >>

Dear All, I need your opinion about implementing replication through dial-up connection using modem 56 kps. What do you think? Thanks Robert Lie...more >>

Hi, I use snapshot replication. Is it possible to transfer only INSERTs from publisher to subscriber. I don't want to update the subscriber for UPDATE and DELETE from publisher. Thanks in advance, Leila ...more >>

I am trying to configure a MS SQL Server 2000 named \\MSSQL_NEW as a publisher but I keep getting this error: SQL Server Enterprise Manager can not configure 'MSSQL_NEW' as the distributor for 'MSSQL_NEW' Error 18483: Could not connect to server 'MSSQL_NEW' because 'distributor_admin' is n...more >>

Hi, We have one publisher, one distributor and two subscriber. We run transactional replication. We recently upgraded all our hardware but now we find ourselves with an unacceptable latency. When the "Distribution Cleanup" process fires it take up to 4 minutes to run and will cause a comp...more >>

Hi, I am dealing with merge replication (104 tables/database). I need to add some new tables in replication. There are two options 1. Stop the replication and publish all tables including new tables then again set the replication. 2. Create a new subscription for these new tables alone A...more >>

Hello, Firstly I would like to apologise if I am bringing up a common subject again, but I cannot find a definative answer to my problem. I am using daily transactional replication to keep a copy of our SQL server database offsite, as a disaster recovery measure. I.E. if our servers go dow...more >>

Hello, I am trying to setup a push subscription between two SQL 2000 Servers using the Push Subscription Wizard through Enterprise Manager. After clicking "Finish" at the end of the wizard, Enterprise Manager hangs at the first step "Enabling this server as a subscriber". Can anyone help ...more >>

I have a Win2K3 SQL Cluster that is currently log shipping to my DR SQL Server and a DEV SQL Server. Everything is working perfectly. For piece of mind, I would still like to do a backup of the production server everynight but that is not possible when log shipping is implemented. What is...more >>

Hello... I have an app that has Merge Replication setup between SQL Mobile and SQL 2000. For the most part, this works great. However, I have encountered an error a few times...not enough to figure out yet....and I am wondering if anyone has any ideas or thoughts. The error message is:...more >>

Hi all, I have what is probably a dumb question... I am getting ready to setup sanpshot replication on a SQL2k server to create a copy of a database at a given moment. When configuring the snapshot initially the default is to run it only once and then the distribution agent is scheduled to...more >>

I have had to fully restored my publisher database. Since then my transaactional replication no longer works with the 'Log Reader' failing to start and reporting the error message "The process could not execute 'sp_repldone/sp_replcounters' on ServerName". I have run via Enterprise Manager...more >>

Hi all, well quick one this, ive been using the sql table sync tools, like RedGate SQL Compare for a while now, however we now have a fair few customers that have replicated databases, and this tool does not seem to work, ive searched about for other tools, and cant seem to find any that wil...more >>

Hello, I have an environment where I have a DB "source" being published from server "A" to a DB "destination" on server "B". The "distribution" database in on server "A". The replication agents are running on server "A". I have a downtime where no users or jobs will be running on the "source...more >>

Hi all. I am working on a SQL 7.0-2000 upgrade testing/planning scenario. My question is: Is there any way to restore a backup of a published DB to a non-replicated server? When we go live, I plan to drop all of the subscriptions and publications before restoring the databases onto the new SQL...more >>

Hello, I have a SQL 2000 database which stores details of consumers input via our website. I am currently trying to configure some off-site disaster recovery, which includes synchronising our database (including tables, data and stored procedures) to another server. We are limited on ban...more >>

I have some confusion that I hope someone will clear up for me. I have a central subscriber doing a "pull" transactional replication from a bunch of servers. I am having problems getting replication going on some of these servers. There are a number of servers, some apparently replicatin...more >>

I am in the process of setting up replication and I know that SQL Server 2005 is coming out in a few months. Can anyone tell me the advantages of SQL Server 2005 replication over SQL Server 2000. Would it make sense just to wait to November and do the replication from SQL Server 2005?...more >>

I'd like to create multiple "replication" on the same database in order to sync only some tables in each replication. When I try to add a second push replication to the subscriber i got the following error: "The subscription already exists." Is there a way to do this?...more >>

Hello, I have a merge replication which use identity range management (for some tables). I have a table that inserted a row on the publisher and tried to transfer it to subscriber. The subscriber got an error when trying to insert it (by the way, I use MSDE on subscriber and MSmerge_contents...more >>