HELP!!!! I have a republisher model type merge replication and a table in the second level of replication is losing all its data and from there its subscriber loses its data also........ ...more >>

Is there an easy way to determine the status/progress of the snapshot agent for a particular merge publication? ...more >>

How can someone temporarily block merge agents (pull subscriptions) from synchronizing with my server? ...more >>

How can you determine if a merge agent (pull subscription) is currently in process? ...more >>

Hi everybody, I want to setup a FTP replication ( snapshot or transactionnal) other 2 SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and domain B). neither S1 , nor S2 can have IIS set. So i want to use an FTP server on domain B to acts as snapshot folder. Do you have ...more >>

Hi. I have a subsription that needs to be reinitialized because it has been marked as inactive. Instead of reinitializing and then have to transfer a new snapshot, that would caus all sorts of key violations, i would like to do the following. 1.Drop the subscription. 2.Add subscription wit...more >>

Hi all, Cannot seem to find an answer to my proposed setup;- HQ Server SBS Server 2003 (Premium) R2 ie SQL 2005 Workgroup Remote Server SBS Server 2003 (standard) with SQL 2005 Express Need to sync the two databases(merge) thru an internet broadband connection, cannot use a VPN as ther...more >>

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 >>

In the SQL Server Mgt Studio, I can look up the database property 'Last Database Backup', which gives the date and time the DB was last backed up. I would like to access that info from within my VB 2005 program. What commands would I use? -- Ed...more >>

Hi, I use a transactional replication and sometimes I realize that all or some tables at subscriber are empty but the agent history don't log any error message. All the informations at the publisher is ok. This morning, I looked to the data at 10AM and all was fine but an hour after some ta...more >>

I want to implement merge replication between SQL Server 2005 and SQL Server 2005 express. My problem is, when we make table schema changes like adding and removing columns, we drop and re-create the table. Is there any way that this methodology can work with merge replication. I know the repl...more >>

Hi all, we have a complicated merge replication/trigger problem. Ill try to explain the setup first... We have 2 SQL Server 2005 servers (called Server1 and Server2 for this example) On each Server there is an identical database (called SalesData for this example) which contains 2 related t...more >>

=DA=E4=CF=EC Server 1 SQL 2000 (SP4) Distributor, Publisher Server 2 SQL 2000 (SP4) Subscriber Transactional Replication set up between Server 1 and 2. All the agents are running successfully (Log Reader, Snapshot, Other Miscellenaous agent...except the Distribution Clean Up Agent =CA=DA...more >>

I've read some varying opinions on this topic.... Is it a best practice to stop replicating a database during a = maintenance window that is doing reindexing? What is the effect of stopping / not stopping the distribution agent? --=20 JUDE...more >>

Hi, My distribution agent failed reporting, "The agent is suspect. No response within the last 10 minutes". I caught this error a few days later and have also discovered that the log reader agent is not visible anymore. Please help. TIA....more >>

I am using P2P replication between two server. I face a big issue in manual identity management. I did as follows Step 1: Built MyDB1 with data in server1. Step 2:Set up Server1 MyDB1 as Publisher (Followed msdn white paper p2ptranrepl.doc) Step 3:Took backup of MyDB1 in Server1 and restore...more >>

Hi, I am working in the SQL Server 2000 and Share Point Portal Server; we are maintaining the SQL Backup for all the sites, one of the users has deleted accidentally a document library from a particular site. Can you please help me in restoring the particular document library from the SQ...more >>

I need to detect whether or not a database is being replicated. I need to do this in a script and use the results in an IF statement. Is the best way to do this by checking the value of category in the sysdatabases table? Something like this … IF EXISTS (SELECT * FROM sysdatabases WHER...more >>