I was adviced to turn Logging on to spot the problem with the consistantly failing Merge Replication Below is the end of the log. I you need the entire log I will add it Percent Complete: 31 select * from "dbo"."tblUser" where 1 = 2 Bulk copying data into table 'tblSolsFeeEarner' [9/30/20...more >>

I just tried to create a Transactional Replication and it failed because the Login for sa failed... I assume that the destination server (for Push Subscription) doesn't recognize the sa of the Distributor What can be done to solve that (when running the wizard I wasn't given any chance...more >>

Hi I noticed this table which was added after I added the first publication Is it normally necessary to include it for replication? It seem to forever get bigger... Thank you, Samuel ...more >>

I cannot find where to change the 'schhedule' in SMS 2005. I can go to EM & do it...by finding it in the distribution agents. Do I have to navigate to the job in the SQL Agent->Jobs folder?? Larry... ...more >>

After working for about 30 minutes (delivering the snapshot) the replication failed I checked the Session details of the subscription and I found Action Message saying the 'The process could not deliver the snapshot to the Subscriber.' In the error information under Data Source I found the...more >>

I am still struggling to delete a subscription so I can set another one to that server I believe that normally that would be listed in the Properties Page of the Publisher, but it doesn't How can I still delete it Thank you, Samuel ...more >>

Hi all Since I had some problems setting Push Merge Subscription I tried to 'Run Agent at Subscriber' while setting it I clicked on 'Verify Subscriber' button and I got the following error: Server xyz is not prepared to run the offloaded agent Error: 1040 The Agent failed to connect to ...more >>

Hi I am looking for a way to avoid the option of 'Yes initialize the Schema and the data' (which I suspect is the source of some problems) when I create a new subscription Thank you, Samuel ...more >>

Hello, I need to automate the replication from live server to test server (i.e weekly backup of a live server followed by restore to the test server). Any pointers would be greatly appreciated. Thanks in advance, Don Diego...more >>

Can anyone tell my why does replication sometimes hold a lock on the PFS page of the subscription DB? The blocked process shows that it is waiting on replication SPID and waitresource is "KEY: 11:1:1 (540080683243)" (11 is the DB id of the subscription DB) thanks....more >>

Sql Server 2000 to Sql Server 2000 Transactional Replication - On Same = Domain No Anonymous Subscribers Nothing Fancy Using Sql Query Analyzer (Got burnt by making the change at EM & having = entire snapshot being invalidated once) Script =3D Sp_droparticle - said I had to force invalidat...more >>

All servers SQL2000 Std Ed., sp4 Transactional Replication Publisher in Hong Kong, distributor in Calif - subscriber in Calif LogReader & Distr. agents on 2 minute schedule. Connectivity lost to remote publisher, the Log Reader (job) gets to Step 3: Detect nonlogged agent shutdown. ...more >>

I have three SQL 2000 servers, with transactional replication between them (27GB database, +2GB/month) SQL1 -> SQL2 -> SQL3 SQL1 is a publisher+distributor SQL2 subcribed to SQL1, and publisher+distributor for SQL3 SQL3 subscribed to SQL2 Everything is working fine, but in the last week the ...more >>

I get this error after I created a push Subsription and the table is very large while the connection is VPN What settings can I change to stop this error? Thank you, Samuel shulman ...more >>

Merge replication set to work every minute. I got this error once but then it seems fine Does that mean that the problem was solved next round (that followed a very big updates to one of the databases 230,000 records) Thank you for your advice, Samuel ...more >>

Hi, Is it possible to setup merge replication between SQL Server 2000 (Publisher) and SQL Server 2005 as (Subscriber) because when i try to setup, it gives me a message that the "subscriber version cannot be higher than the publisher version" ? If transactional replication works, why not ...more >>

I'm trying to add a column to my peer to peer replication. According to the help I've found: Adding Columns a.. To add a new column to a table and include that column in an existing publication, execute ALTER TABLE <Table> ADD <Column>. By default, the column is then replicated to all S...more >>

We are currently doing an exhaustive test in our QA enviornment to make sure that all stored procedures, sql commands, etc. do not cause any replication errors. During our tests I have caught a couple of errors (e.g. one table had cascading deletes checked and we weren't explicitly deleting t...more >>

Hello, thank you Raymond and Paul, please bear with me a little longer: It really seems like running sp_addscriptexec is the solution for me, Thank you again. So I have run: exec sp_addscriptexec 'myPublication' , '\\myDataBase\shared\udt_script.sql' , 0 I know that myPubli...more >>

Running SQL 2K & Win 2K I receive the following error message when the snapshot agent runs on my merge publications. Assert failed: @indid is null in sp_MStablekeys (pk/uq) (Source: MSSQLServer, Error number: 12241) Anyone have any idea about this one?? Larry.... ...more >>

Thanks for the response Hilary. It looks like we lost the rest of the thread so I'll recap: I am running transactional replication between our radiology information system database server and a reporting server. I am only replicating the data we need for reporting. The replication was set ...more >>

I would like to publish data to other SQL servers, however I'd like to have control over how the information is published. I may not include all of the fields, may change the name of the column, or perform a simple transformation on a column. Is replication the best approach? I tried to...more >>

Hello, Yesterday I had a failure due to a key violation. Someone had entered some rows manually into a subscription table (a web developer for testing). I removed the rows, clicked on reinitialize on the particular transaction (which replicates 4 tables). Then I clicked on "Start Agent" ...more >>

I am trying web synchronization for merge replication between Client A which has SQL Express and Server B on an internal secured LAN which has SQL Server 2005 as the default instance, separated by a DMZ IIS Server, lets call it Server A. Server B runs the SQL Server Agent that puts snapshot...more >>

It may be simple but I find it difficult to delete a subscription. When I right click the subscription I don't get this option and I can only delete it by deleting the Publication ...more >>

When setting 2 servers to replicate (in the case of Push Subsription) at what point one computer will log on to the other? I am having some login related problems and I would like to understand the tehnicality of that aspect Thank you, Samuel ...more >>

I keep getting this error in the Queue Reader How can I set the way the Publisher logs into the subsriber (push subsription)? Thank you, Samuel ...more >>

Assuming that there is an exiting replication in place between ServerA and ClientA (subscriber) and now I want to add another subscriber ClientB How do I go about that Should I just copy the database from the serverA and add a subscription to ClientB or I have to do something to the Public...more >>

How many Distributor Agents (Distrib.exe files) SQL Server 2000 work better? There is any limits? -- Message posted via http://www.sqlmonster.com ...more >>

Hi, I couldn't delete a replicated db after I disabled the database as the publisher. any ideas??? Thanks, ...more >>

Hi, We have a failover database that is currently run using log shipping, this means that the fail over is unusable. What we would like to do is use a tool such as replication to instead ensure that the fail over database is kept in sync and we can also use the fail over database to run out...more >>

Hello, I am not a sql server programmer. I have a database which already has a publication set up, which sends a bunch of tables to subscribers. Everything was okay, but now I need to publish two more tables. These tables contain columns which are user defined types, which means my subscribers...more >>

Hello, We had a push failure on a transactional replication table. The error message said "Cannot insert duplicate key row in object 'SubDetail' with unique index 'PK_Web'" One of our clients complained that he could access his information on our website. That is when I looked at th...more >>

I have set up web synchronization for merge replication with SQL Server 2005 on both sides. Windows Synchronization Manager is used on the client. The server is accessed through the internet using SSL (e.g., something like https://servername.com). The subscription was set up as anonymous pe...more >>

We're running Merge replication on SQL 2KSP4 and I'm trying to add a new table to the publication using sp_addmergearticle, the identity range is correct for the publisher and for the first subscriber that syncs, but all other subscribers will have the same range as the first subscriber - it l...more >>

Ok so I rebuilt the replication. Using all of the default options except snapshot location. It worked fine. The 1st time I added a table, it worked fine. The 2nd time I added a table it repeated what happened above -- couldn't find the SPs. I tried adding them manually but it only created...more >>

Hello, I have replication in place between 2 sqlsvr2000 DBs. Everything is working OK. I am looking to upgrade the publishing sqlsvr from sqlsvr2000 to sqlsvr2005. The subscription sever will remain as a sqlsvr2000 server because I don't own that one. If I were to go ahead an perform th...more >>

We are in the process of setting up an Off Site backup Server. Our production Server is currently Window Servers 2003 with TS, and we will be using DFS to duplicate the data on the other Server. Both Servers will be running GoldMine and SQL Server 2000. The queston is, will we be able to us...more >>

Hi guys I'm trying to test replication between SQL Server 2005 and SQL Server 2005 Express - to see whether a) it will work, and b) whether there's any kind of latency. Basically, we want to setup an Intranet system where if one server fails - the second server will pick up and carry on. ...more >>

I have Transacional Replication Cenário. We use one full filter table replicated. This tables have been used with other, but we need add parameter filter subscriber. I mean, in this query below we need <<subscriber_parameter>> to connect with anyone subscriber to filter data. T400clou is table ...more >>

Hello! anybody know some tool to synchronizate data between databases (two databases has the same structure) . I can not use replicate becouse I have not a permanet connection between servers. Now, somebody can send me a backup peridocally using email. And I can restore in a second database in...more >>

I have a VB.NET application that does merge replication using the SQLMerge control, and I thought I would try to move over to using the managed RMO assemblies instead of having the merge control. (The merge control works great when used directly, I was just trying to eliminate a dependency) ...more >>

Running SQL 2K & WIn 2K A dB appeared as suspect. I ran sp_resetstatus 'dB', restarted SQL & it is still supect. When I run sp_detatch_db 'dB' in QA, it will not allow this because the dB is being used for replication. The dB is 5 gig & log is 34 gig (it has not been getting backed up, ...more >>

Hi Im using sp_addarticle to add a new object to my pub - this works fine. I go to look at the properties of the publication, and my new artticle is sitting there with a tick. Great. I am however told that I must set the force_invalidate to 1....When I re-run the agent from the EM console (...more >>

Hi, I'm using two instances of SQL Server 2005, one as both Publisher and Distributor, and the other as Subscriber. My merge publication has two tables but its job doesn't succeed. I get this error in the job history: Unable to start execution of step 1 (reason: The Merge subsystem failed t...more >>

Hello again all, I know SQL 2005 supports backups for intialization... But does SQL 200 support it? Thanks, Michael...more >>

Hello all, Just wondering if there are any formulas for calculating the snapshot folder size? Thanks, Michael...more >>

I'm using a replicated SQL Server 2005 database on my server and a SQL Server Everywhere CTP (v3.1) database as my client app. Everything works fine (including sync) until I add a row to a table on the subscriber (client). Upon the next synchronization I get the following error: 'INITCOLVS'...more >>

Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything works great. Our application runs on two IIS web servers and connects to the SQL back end. When people are running reports the SQL server can get taxed. What is the best replication method where uses can connected ...more >>

Hi, I am beginner in replication I use a merge replication with a pull subscription I Use sql2000 Server 2000 for Publisher, Distributor and all Subscriber use MSDE I insert a new column in the temps tables This table contain 161 thousands rows I use this script to insert the new colu...more >>