I am trying to send it again as I had no response. I would like to start transactional replication in continuous mode but the only thing I dont want is having the distribution agents started . I would like to start the distrib agent jobs manually after we check a few processes ...more >>

I'm building a distributed sales system with a central database and about 50 not-always-connected sites. The schema is something like this: Customer Id uniqueidentifier (PK) Name varchar Invoice Site int Id uniqueidentifier (PK) CustomerId uniqueidentifier Total m...more >>

I keep getting an error 511 when I try to publish a table. It says that the row size exceeds the maximum row size of 8060 bytes. I hear that splitting up the table is one way, but this table is an integral fixture across many apps in our system (we've been using it for years), so redesigning i...more >>

I have a Sales Person running Merge Replication that is suddenly get conflicts when synchronizing. Some of the conflicts give the message "String or binary data would be truncated. A similar thing happened a year ago and one field was too small in a table when a audit trigger fired. I captured...more >>

Hi all. Im trying to set up replication from Enterprise Manager to one of my databases. I have successfly done it for the Northwind database in this server but now I get this error when trying to do it for another database. The complete error message I get when I click on the Finish button of ...more >>

Hi! We are attempting to replicate a SQL 2k (Win 2k) server with another server of a very similar spec but the whole process has been a disaster... Firstly merge replication pushing the subsricption seems to constantly have a status of "deactivated"! If we use pull subscription, the sub...more >>

I have a table that is part a merge publication that I need to delete 3 million rows from which will leave about a million in the table. I plan to just insert a list of the id's to go in a temporary table and then just do delete where id in table X. Another way that has been suggested to...more >>

My Log Shipping process has been up and running fine for about 6 months now. Then as part of the preparation for upgrading the front end application for the log shipped database, my partner DBA thought he would help the backup speed by running a SHRINKFILE over the database files. It was o...more >>

I am using merge replication and trying to configure an alternate synchronisation partner (ASP). My topology is V-shape and replication is working OK as long as I do not perform a sync of the subscriber with the ASP. My subscription contains articles having identity columns managed by merge ...more >>

Hello, I have 600 gig of data on my disks on windows 2000 server with SQL Server 7.0. I am using robocopy for fast data transfer between 2000 and 2003 disks. but my application team wants to set up replication for exact data sync, i mean after files with robocopy, i want to set up replicat...more >>

After working for over a year, one of our snapshot replication distributions now fails with the following error: The process could not bulk copy into table '"texttab"'. Expected the text length in data stream for bulk copy of text, ntext, or image data. (Source: DESTINATION_SERVER (Data sou...more >>

Hello, I have to do a task, but I'm newbie in sql server replication, so I ask you what I have to do in this case: I have two SQL Servers A and B. What I have to do, is to synchronise some tables from these databases. So when I modify a table in srvA, to update in srvB and vice-versa wh...more >>

Hi, the idea is to setup an offsite backup of our single sql server, have created a publication on the MASTER server, and pulled it to the offsite server using FTP, downloaded snapshot, replicated transactions, all appeared to work, generated schema, but the frontend database app didnt run,...more >>

I have two databases say A and B on the same server. A is updated through an Access front end. A is set up to transactionally replicate some of its tables to B. The Log Reader does its job - confirmed by running sp_browsereplcmds to see the content of MSrepl_commands. However the Distributio...more >>

Hi, I have one publisher and two subscribers, i want to filter the data dynamiclly before sending it to the subscriber(s), my question is, how to know the current subscriber when the merge agent implement the filtering criteria, i tried to use Host_Name() function to know the current subscr...more >>

Hi, has anyone of you experience in replicating Commerce Server 2002 DBs between two sites? Both sites' web servers are accessible from the internet. Placing orders should also be possible on both sites. Is there any recommendation / experience which replication model (mix) is to be used i...more >>

I'm considering a solution to retrieve user selections from another source and automatically use them to set my SQL replication filter criteria. The filter includes at least one table join. Is it possible to set replication filter criteria programmatically? ...more >>

Hi, I am setting up a disaster recovery server and I need to configure it so that databases on the main server get copied every few days. I thought of doing an export with DTS and then saving the package and set it to run on the specified dates, but the problem is I would have to remember t...more >>

Hi, We have two DataBases Residing on two different Servers. We would like to set up real time uodates between these two servers. We have an Inventory System on server A and a Tracking System on Server B. Now an Transaction in Server B should Update a Certain Table or Tables on Server A. and ...more >>

I have set-up Transactional replication with a pull subscription, for a database that we are playing with at the moment. Had a few issues getting it running, but now it is doing the job. The only problem I have is that the database on the publisher, has Primary Keys specified, but when the d...more >>