I have a merge agent running extremely slow - schedule fires every 1 minute, however it takes 1 to 3 minutes to execute. Delivery Rate 5 rows/sec or less, all 5 other merge agents execute in less than 20 seconds and Delivery Rate 80 rows/sec or greater. Each time merge agent fires, subscr...more >>

I have a database which I converted from SQL Server 2000 to SQL Server 2005. I did this by detaching and attaching. I am trying to set up merge replication and I am getting the above error. How do I get all the system tables updated to SQL Server 2005?...more >>

I have SQL 2000 tables (5) that I want to replicate to SQL 2005 Workgroup on Remote web Server which need to synchronise else say twice a day but without taking Remote off-line. How can I achieve this?...more >>

I=B4m using MS SQL2000 and have and replication scheme with log shipping. Is posible replicate by log shipping or transactional replication schemes this DB=B4s Thanks ...more >>

I have a merge replication case with pull subscriptions. The pubsliher is SQL Server 2005 SP2 and the subscribers are SQL Express SP2. I am running the merge agent through custom C# code that is using RMO. I implemented also a custom business logic handler for one article. In my handler I a...more >>

Hi I've configured push Merge replication between MS SQL Server 2005 Standard and MS SQL Server 2005 Express. What kind of difficulties will I experience if I don't recreate replicated tables during the reinitialization of subscribers? -- Thanks, Oskar....more >>

So if I have a remote location running Express that needs to publish data to a central server, Enterprise edition, can I do that or is it not possible due to Express being a Subscriber only for Merge and Transactional Replication? If this is not possible, what would be the best way to handl...more >>

Hi, I am constantly getting data validation failures happening on the same table when reinitialise all subscriptions. This has been happening for some time now and taking a new publisher snapshots does not fix the problem. Normally when the subscriber syncs again it clears the error but this ...more >>

I find the replication put many sprocs with sp_ prefix in our database. Do you think that should be changed? I have been told not to use sp_. See http://www.sqlmag.com/Article/ArticleID/23011/sql_server_23011.html. ...more >>

Hi, I have a problem with merge replication overwriting data without any reason. Here is my setup: Publisher/Distributor runs on Windows 2003 Server Subscribers running on Windows 2000/XP using SQL desktop engine. Subscribers update/modify data via an application and sync back to the pub...more >>

Only recently, I am starting to get a 49999 SQL Server error when performing log backups. The error message states: "The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as ...more >>

All, I can seem to find much info on this. I'm trying to determine when and if I need to rebuild the indexes on the Distribution database. We're running transactional replicaiton 24/7 so I'm concerned it will interupt service. Thanks in advance....more >>

hi all any one can help me in this problem? the ranges for identity field for some subscriptions seems to be invalid ranges,so when I insert a new row I get this message: Major Error 0x80004005, Minor Error 25081 The new value generated for the inserted row is outside the range for an INTE...more >>

Does anyone know what causes this message? The row was inserted at 'CVTDEESQL005.ZenithSQL_L_060104' but could not be inserted at 'ICK24BQZ0J.Zenith'. Procedure or function sp_MSsetrowmetadata has too many arguments specified. Our conflict log seems to be full of them ...more >>

I am using sql server 2000,I want to know, if there is any scenario or error in transactional Replication,which we can solve just by stopping and starting the log reader Agent and what will be the possible consequences. Thank you...more >>

I have been trying for almost 2 days now to create a subscription to a SQL Server 2005 database but I haven't had any success. After reading all of the documentation and installing everything, the problem seems to have something to do with permissions. Here is what works: * Created the a merge...more >>

Hi: we are getting violation of unique constraint in distribution database. We stoped and restarted the distribution agent but still the same error. There are no duplicates in publisher and/or subscriber. It seems like a record was deleted in publisher but did not get deleted in subscri...more >>

This one is driving me crazy... We are using Transactional Replication with the subscribers initialized from a backup (no snapshot). It's working great, but now we need to add several new articles to the publication and have them picked up in the subscribers. The only way I can get this...more >>

Hello, I have a couple of tables containing lookup data I need to replicate into a database on a different server. Originally I was just copying the data acros via DTS but now the target tables are referenced by a foreign keys on a table this no longer works as I cannot clear the tables out...more >>

Hello, We have SQL2005 Server, SQL Mobile 2005 CF2.0 application. It seems that when we mark Orders as complete on the server, it redownloads all OrderDetails from the server down to the PDA, even though there are no changes to this table on the server, and there are changes on the PDA that ...more >>

I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The remote copy of database "ABC" has not been rolled forward to a point in time that is emcompassed in the local copy of the database log. (Microsoft ...more >>

SQL Server 2005 Hi, I found the alternate snapshot folder path in table <PubDB>.dbo.sysmergepublications but I can't seem to find the view/ table that will return the default snapshot folder path - does anybody know where the default snapshot folder path is stored? ...more >>

All, We are replicating 500 articles and are flowing around 30 - 40 thousand rows across the atlantic. Please note that we are replicating between two sql server 2005 servers and are using character mode for bcp and only T-Rep data only. On average it takes around 20 minutes to apply these ...more >>

Hi I have transactional replication for setup for only two small (170MB & 60MB) databases, however when I configure the subscription and tell the snapshot to create the database and apply the snapshot file, it doesn't create the database on the subscriber, so the snapshot runs then I get an e...more >>

I have a customer who has about 80 SQL 2005 servers in remote offices with various WAN links. The distribution of the SQL servers are as follows: - 15 site servers (publishers) must update to a single regional server (central subscriber), there are about 5 regional servers, each with their o...more >>

I have 2 servers both running SQL Server 2005. I have setup transactional replication for 149 databases from one to the other. Everything works perfectly, except on a reboot of the publisher. After a reboot only 100 of the publications logread.exe's startup. I can manually start the rema...more >>

Hello, We are running SQL Server 2005 SP1 Developer Edition x64 on Windows 2003 Server R2 x64. We have setup transactional replication. The same instance has the Distributor and Subscriber, and another instance has the Publisher. The readme for SP2 says to upgrade the Distributor, Publis...more >>

Hi, I need some help desperately. Here is the situation. I am doing push transactional replication. The publisher and distributor are on the same SQL 2K server computer and the subscribers are on two seperate servers. One subscriber server is SQL 2K and the other subscriber server is...more >>

Hello, I have set up transactional replication between two SQL Server 2000 (SP4), I am facing problem while updating Text data type column under replication from my staging to my live server, The Text data gets updated in the staging server but it doesn't get replicated to the live server. ...more >>

Hi group, I'm hoping someone can explain to me how SQL Server 2005 decides how long to hang on to snapshots for. I have two publications: one transactional without subscriber updates and one merge. They are used by a number of mobile devices to pull reference and transient data respectively...more >>