we have setup a sql2005 server for reporting. we want to replicate the transaction databases which used for live applications to that server such that all reports will be generated in that server. This reporting server is supposed read-only and with let's say 30 mins delay from production...more >>

Good day all, Is there anyway to run this to set the sync_method = 'native' without having to also having to set the force_invalidate_snapshot = 1 ? Here's what I'm trying to do: SQL2000EE (SP4) on Win2000AS (SP4) Transactional Replication -Single Publisher/Distributor with one Publica...more >>

Hello, I need to migrate my data from a SQL2000 -> SQL2005 server (250 GB of DBs) accross a moderately slow link (100 MB) with a minumum of downtime. Backing up and restoring the data isn't feasible because the time that is required to copy data then load it. I was hoping to perform Log S...more >>

I have a Sql 2000 Citrix data store on a server which is licensed per processor. I have established replication on this server to another server. This other server (the Subscriber) is running sql 2000 also but at this time is only licensed for 5 seats. Would I need to license this subscribe...more >>

Hola a todos, tengo una duda sobre la replicacion.les comento el = problema: Hi Everybody i have a problem with replicacion, i tell my problem. Situacion Actual (Spanish) 1.. Tengo 2 DB, llamada CPM Y CPD respectivamente en mi oficina(zona = residencial -comercial), con su respectivo servid...more >>

Good morning, This morning I opened up enterprise manager (sql Server 2000) and noticed a blue return arrow looking icon on the Replication Monitor folder. When I opened up Replication monitor I observed the same blue return arrow looking icon on the publishers and agents folders. What is...more >>

I have a small problem, I get this following error when trying to start the snapshot agent "The process could not connect to the distributor 'distributor name'. NOTE: The step was retried the requested number of times [10] without succeeding. The step failed. I thought it was related to users ...more >>

Hello. Let me paint the picture :-) I am a Windows Engineer and I have been asked to create a trust between two domains, this request has come from our SQL engineers who tells me this is required to set up SQL Replication. Basically there are 2 servers both having SQL 2005 installed on ...more >>

I want to deepen the function of Merge Replication: 1) what's the main difference between a push subscription and a pull subscription ? 2) if I have a subscriber node that for many time (4-5 months) is disconnected from publisher, what will it do when it'll be re-connected to the network ? ...more >>

Hi We have configured merge replication in SQL 2005 (SP 1) for a database having more than 100 GB. The merge agent duration was for every 5 mins. Normally it used to take around 2 to 3 mins to complete. It was working fine till now but now it is taking around 45 minutes. When checked and v...more >>

after i done the replication from sql server 7.0(pub/dist) with sql server 2000(subscription) there will promt out the error like below : Agents Last Action Snapshot No such interface supported.NOTE:The step was retried the requeste...more >>

I'm trying to implement .NET based custom resolver for SQL Server 2005. MS example shows how to work with publisher / subscriber record data only. To resolve a conflict I need more info about the business object represented by record data. I need to run a query / procedure for this purpose. To...more >>

If I delete a record in the client database and then replicate it will reappear on the client. It seems that i have to delete it 2 or 3 times before it finally "sticks". Can anyone explain what's going on here? kind regards Spike...more >>

Hello , I am reading all the texts again and again, still not able to understand what to really do. Database we replicate to notebooks potentially contains a lot of data. I may understand what to do, if I want to alter column using method you call 'altering the table in-place.' , and usa...more >>

hello, i need your help. i have a transactional plublisher database, with updatable subscribers, and used a queued update. i have a lot of problems, first i need to use triggers in both siders, to update 2 replicates tables, and now i have many conflicts, because they update both records. ...more >>

Hi, I am using SQL 2005 in merge-replication with sql mobile. Can anyone tell me a way to set the transaction for upload from pocket pc only? Thanks, Luke ...more >>

I have two publications on a SQL Server 2000 database. I am able to create two subscriptions from another SQL Server 2000 database and synchronize both in succession. However when I try to repeat this going from SQL Server 2000 to SQLCE 2.0 it fails. The first goes OK. The second fails. I ge...more >>

Hi, Can any body tell me how to reinitialise a transactional replication. Regards Balaji.T...more >>

All, I have re-initialized snapshot for my transactional replication which failed last night. Now it is failing with error message "The process coult not bulk copy into table <table name>" The error details is as below. Violation of PRIMARY KEY constraint 'pk_Name'. Cannot insert dupl...more >>

Hi. I have a problem with trigger FOR in merge-replication. My trigger is not "NOT FOR REPLICATION" and it's modified table with beyond replication. In replication this trigger not fire. Why? Thank's for help. PW ...more >>

Any suggestions? Can anyone set up the simplest of replication from SQL 7.0 pub/dist to SQL2000 subscriber? thanks a lot...more >>

May i do the replication from sql server 7.0 to sql server 2000? Any steps to do it?...more >>

i have a merge replication. it runs well, the subscriber disconnect from the publisher about 5 days, then i reconnect it to publisher. theoretically speaking, the changes made during these 5 days made on both publisher and subscriber will merge into one copy. but customer complain about data m...more >>

I have set up a two level merge replication with a publisher and a subscriber and had modified the structure of a table in the publisher with sp_repladdcolumn. During the day all was fine I continuously tested it by adding more columns, droping columns and testing the replication itself with da...more >>

Hi I am creating a three level merge replication. I mean I have a main publisher with its distributor, a subscriber/publisher and also with it's own distributor and lastly a subscriber. I start by creating the relation between subscriber/Publisher and the subscriber and than I move up to the mai...more >>

I setted a configuration with 2 SQL 2000 servers, 1 publisher and 1 subscriber, to manage a merge replication of a DB, with the wizard of enterprise manager. It seems that some tables published as arcticles are not synchronized correctly. I'm a newbie using SQL Server 2000 and I don't know how t...more >>

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_moviecats_cats'.With trans repl and DRI enabled, I get the above error once and a while.It seems as if replication is not deleting the rows from tables in proper order so that this doesn't happen.Enforce relationship for replic...more >>

How to script all Publications using SMO in 2005 Hi Paul / All, I have used your script from you site www.replicationanswers.com to script all publications in SQL 2000 . Work great thanks !!. I am now testing SQL server 2005 – what is the way to work with SMO in order to scr...more >>

Hi, I am a newbie dba and relatively new to replication area. I am in a process of setting up a transactional replication on sql 2000 for a reporting purpose to offload this activity on the production server. My basic goal is to enhance the performance on the production server. I thought...more >>

All, My setup involves multiple publishers connecting to a centralised subscriber. They follow transactional pull subscription. My doubt is as follows: Tables at publisher do not have 'Delete cascade' set to active on any PK-FK relations. However i thought i could set the property to true...more >>

"The identity range managed by replication is full and must be updated by a replication agent." my merge replication agent is constantly running and syncing. why isn't it re-seeding the values in the ident. cols ? ...more >>

We had a employee or someone delete all of the snapshot agent jobs on our server. Don't ask me why they did this, I don't know, but when I find out who did it they will have "a lot of splainin to do" (to quote Ricky Ricardo) Her is the question, how can I recreate these snapshot agent jobs w...more >>

Hi, We are using transactional replication with queued updating between SQL2000 Servers (Win 2003). 1) The queue reader has failed with the error message "Queue Reader aborting. The step failed." The error details stack shows (from last to first): Queue Reader aborting. The step failed Pro...more >>