Hi, I accidentaly remove a publication, I need to restore it!!! What Date Base I must restore??? I Restore de Distribution database and only restore de Agents but not de publication. ...more >>

Hello, we have merge replication setup on sql2000 sp3 with all the hotfixes. Every year we do our rollout of the database. This year we are just concerned with the size of our database. we have 8 gb of databse and just wandering if we are going to run into any issues with creating a snapshot ...more >>

I am confused about how to interpret the Merge Agent History panel and the Session Details of the Merge Agent panel. The Merge Agent History panel has columns to the right that indicate pretty clearly where the action is occuring, at the Publisher and at the Subscriber. In my case I see lots of ...more >>

One Server and many clients . How do I set it up that my clients can replicate with my server. ie Create the replication. I am using foxpro as my front end and sql server as my back end. With SQL Server I can use Enterprise Manager to create the pull subscribtion .. Work well. But the clien...more >>

The further I delive into SQL Server replication, the more apparent it becomes what a complete and utter lash-up the whole "technology" is. Has anyone ever encountered this particular problem? I have transactional push replication in use, with a publication with @centralized_conflicts='fal...more >>

We received a log reader error: "Could not get license information correctly." The log reader ran again soon after and worked just fine. Then on the next run it got the error again. Both sql servers are running sql server 2000. Could the error actually be related to blocking or some...more >>

I am new to replication. Please forgive me if this sounds silly. I have one publisher and several subscriber, all in different locations. In case of emergency and I have to shut down the publisher, I want to use the one of the subscribers to process our business, and I want to turn this sub...more >>

Hi all, I want to change the actual structure of FK constraints, and I have 300 tables. In order to implement replication with PK on subscriber I have to change the option into NOT FOR REPLICATION. With this query I can view tables that to not have this option enabled. select table_name,...more >>

I have 2 computers in a network with W XP SP2 and SQL 2000. I tried to publish and subscribe a database for merge synchronization. No mater what rights I give to different users and how I log on, the SQL Server agent give me the mesage : "Login failed for user '' Not a SQL trusted connection"...more >>

I am Merge replicating from MS SQL Server 2000 SP4 to a MS SQL Server 2000 SP3 box. Get the following error while running the Merge Agent: Error Message : The process could not log conflict information. Error Details : The process could not log conflict information. (Source: Merge Replica...more >>

Hi, When i am changing Log Shipping job owner in Monitor server, stand by server and primary server, i am getting error as "Error 14269:Job 'Log shipping alert job-backup' is already targetted at server. xxxxxx(SQL Instance) The Job was not saved. please advise how to chnage the Job owne...more >>

I'm using SQL Server 2000, and have set up snapshot replication with many anonymous pull-subscribers. This has been running without problem for about 30 months. The replication agent runs every night and creates a new snapshot, but recently, when my subscribers synchronize, the distributio...more >>

We run our distribution on another server ie not on the publisher. We have had some hardware errors and to be honest it's an old machine and spares are getting sparse. Is there a step by step for moving distribution to another server? Thanks Paul ...more >>

How best to move a replicated database? I have a situation where the customer's data is currently being replicated (merge), but I need to move the database to another machine -- without breaking replication. I'm thinking, script out the database, then export the data. Then run the script to ...more >>

Hi All I have servers A, B and C with databases. Server A is a Publisher and Server B is the Distributor/Subscriber. Server C is a Subscriber. Server A replicates 7 publications to both server B and C. Initially when the publications were very small, there were snapshot replications from A...more >>

My company is planning on setting up Reporting Services for our application to report from a secondary SQL Server instance. But we want to archive data to our secondary instance and be able to "clean up" our OLTP instance when data is no longer needed on the transactional side. We would like...more >>

Hello, I am trying to create a Push Replication from Oracle 9i to SQL Server 2000. Does anyone know of any tools, or application utilities for doing this? Thanks in advance!! DB. ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysof...more >>

Hi, I would like to add a new table in merge replication (200 tables already in replication). I followed the steps. Step 1: In publication properties I included the new table Step 2: System shows the following messages One or more tables have already been published. Do you want to upd...more >>

I use MSDE 2000, and i do not possess SQL SERVER. I try to synchronize (with windows) a pull/merge subscription and obtain the error (translated from french) : the snapshot is not yet available. How to generate a snapshot with Transact-SQL stored procedures ? Thanks....more >>

Hi, I am trying to test the transactional replication process. I tried to check on one of the stored procedures and the stored procedure was replicated for the first time that I started the Snapshot Agent. Since then, even I changed the content of the stored procedure or I re-started the ...more >>

I'm getting a bit rusty on replication, so my question is... From what I remember, the Distribution database stores all the replicated transactions... So with that said, it's OK for the Publisher database to be in either Bulk Logged or Simple... Is that correct? Thanks, Michael...more >>

Hello, I'm trying to set a transactional replication. Everything is working very well, but i don't know why primary key and default values are not transfered to the subscribers. Any idea !!!!!!! Thanks...more >>

Hi All, Please help. I have added a column of datatype int to published table. I used by "sp_repladdcolumns" and droping and recreating that article alone. In both cases, I can see that new column is seen on the subscriber database. But updates made to that column on publisher is not ge...more >>

Hey guys. I've 2 servers with SQL 2000. I've a publisher/distributor and a subscriber. Now, there is a queued updating setup between this two with push replication. I'm trying to replicate the employees table of Northwind database only. the primary key is setup to use identity ranges on the 2 ...more >>

Recently started getting an oddity, perhaps after upgrading to sql sp4 (server and msde clients) or in combo with Win 2K3 sp1 server upgrade. Previously healthy pubs/subs when sp3. New Symptoms : 10% of msde synchs stop connecting. 80 anon pull subscribers, 1 push. Push subs can't reach...more >>

I am getting blocking issues on my publisher/distr server cause by random anon subscribers (msde). The offending sid shows "sp_MSenumchanges" is running. Looking for a solid cause and fix or work around. The blocking shows x lock on tempdb, normal locking on msmerge_content and s lockin...more >>

I am considering transactional replication for synching 2 SQL systems one way. A major concern of my customer is that the interface should have very low latency between commits in 1 system and the synchronised data appearing in the second system. the target is 0.5 seconds. There is likely to ...more >>

Dear Friends, I have two WAN sites connected with VPN tunnel with Diffrent domains. I want to create a offline backup of the main database which is almost 2 gb in size. The tables in the Database are having maximum numbers of columns i.e. 1024 and hence i can not use the replication of the ...more >>

Is is possible to move a complete replication-scenario to other computers using backup and restore? I realized, that a normal restore of a subsciber database loses all the replication-tables. Is there a way do perform this action without losing the current MSMerge_Content data? I need th...more >>

We have adjusted our access/sql 2000 project to cope with merge replication by changing autonumber primary keys to uniqueidentifiers. This has primarily meant some design changes in the project forms and VBA coding. However it has also meant that we have had to change our foreign keys to type ...more >>

Hi, i need to make a synchronization between a sql server 2005 express and sql server 2005 mobile. I think this is not possible using merge replication and RDA. Was this right? If so could anyone help and present a possible workaround for my problem? Thanks in advance, Nuno Silva....more >>

Using Merge replication. Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4. Using anonymous subscribers that use the SQLMerge object to invoke replication. Our laptops are everywhere. Some use highspeed internet, some dialup and some cellular modems. When using the...more >>

Using Merge replication. Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4. Using anonymous subscribers that use the SQLMerge object to invoke replication. We've run into issues where the publisher has deleted subscriber records so we are changing all of our FKs for ...more >>

I have setup transaction replication using seperate server for distribution box. Server A - Publisher (Win2003, SQL2000 SP818) Server B - Distributor (Win2003, SQL2000 SP818) Server C - Subscriber1 (Win2003 and SQL2000 SP818) Server D - Subscriber2 (Win2003 and SQL2000 SP818) Server E - Sub...more >>

Enterprise Manager hangs every time I try to disable publications. I tried stopping, then deleting individual subscriptions before trying to delete the publication, but EM would hang after each one. I gave it 30 minutes to complete, but it never came back. Now I have phantom subscriptions on ...more >>

We have 3 databases, one publisher and two subscriber. Merge-Replication, constantly replicated. Because of unknown circumstances, the replication process failed for over 14 days, and the publication had a retention time of 14 days. I wasn=B4t detected earlier, and now is the great question:...more >>