We are standing at 3 level merge replication, SQL2000 SP3. One topmost server, couple of mid-server republishers with 1-4 subscribers (3-rd level) each. The replication strategy is working smooth for about 4 years, but the strange behaviour we noticed starting month ago. One of republishers...more >>

I dropped these tables MSreplication_subscriptions and MSsubscription_agents used for replication on the subscribing end. How can I recreate them since its a system table. ...more >>

When I try to configure this server to be it's own distributor, the wizard gets as far as "Configuring distributor" when I get the error that it cannot be set up as the distributor for itself because "Error 14114: '(null)' is not configured as a distributor". How can I fix this problem ? ...more >>

I was looking for input on a backup plan for a transactional replication scenario. I know you need to back up all the players invloved (msdb, distribution, publisher, and subscriber). I was curious as to the timing of the backups. Currently, we back up the production database once at midn...more >>

I was going through this link and had a question with regards to caveats when new articles are added The link is http://www.replicationanswers.com/NoSyncInitializations.asp So Say i have nosync initially setup and everything is going on fine. I now want to add new articles to the publication...more >>

When does the login distributor_admin get created ? I scripted out the entire replication creation but dont see any reference to creating that login ...more >>

I had meant to fire the @sync_type ='none' with the sp_addsubscription and had all data present on both publisher and subscriber. My snapshot hasnt started yet, so how can i avoid pushing the whole snapshot again when the snapshot agent runs ? Using trans replication ...more >>

We have a replication topology that includes a SQL Server 7 Publisher & Distributor to a SQL Server 2000 Subscriber using Transactional Replication. Currently, the SQL Server 7 server is on SP4 and the SQL Server 2000 server is on SP3. The SQL Server 2000 SP4 install documentation doesn't ...more >>

Can I download a replica on day 1 and then on day 7 download the delta to that replica? Delta is the set of new records added to the server (from day 1 to day 7) after i dowload the replica. Say on day1 I download a replica of 1000 records. Between day1 and day7, the server recieved 10 new r...more >>

Hello to all I am transfering SQL 2000 server databases from one server to another server. I need your tips and help i have around 600 users on the old SQL server how can i transfer all these users on the new sql server as they have same rights and privilege to access the database on the new ...more >>

Is it possible to set-up replication between two servers that are never directly connected? We have a production server that is not connected to our network for security reasons. I am doing testing on a local server and then want to periodically apply the updates to the production server via...more >>

Is there a way to delete from a table but not send any meta-data into msmerge_tombstone? I have readonly data which I delete every morning and have an integration run which brings me my new data. Problem is this creates TONS of meta data which is totally unnessary. tia Rob ...more >>

We are moving some dbs off of some server. Some databases are publishers while some are subscribing . There are some thats a combination i.e they publish some and subscribe to some.. different tables I have done a full backup of all these databases and have restored them on the new server. I h...more >>

We are getting a conflict error message "cannot synchronize, row was updated outside of replication". We cannot figure out what is causing this. Can having different foreign key constraints at a publisher and subscriber level cause problems with merge replication? Sorry for the lack of in...more >>

is there a way to tell the status of a clean up agent? Nothing is in the history for him , but when I right click on him my option is "stop agent".. start agent is grey'd out which tells me he is running. I do a sp_who2 on the dist. and don't see anything about him there. What else ca...more >>

Hi All; Is it possible generate a snapshot only with scheme and without data ? I have a transactional replication with more anonymus pull suscriptions over Internet with FTP, and when I add a new article to publisher, I need generate a new Snapshot for propagate new article to suscribers. ...more >>

Hello! I am student and i need some help from you. I got one task and i need guide line and hints to solve this problem 1: From old SQL server 2000 must delet replication scripts and users 2: Check at Jobs, DTS and Security on the SQL server is OK 3: synchronize DataBase users in SQLDBA_NEW...more >>

How do I set all the IDENTITY columns for all the tables in a data base to NOT FOR REPLICATION in one shot?...more >>

hello, I'm trying to setup transaction replication between two sql servers. My questions is i'm going to be replicating the entire database so how does replication dela with triggers? If on my publisher user enters data and the trigger kicks off that updates other records how does replicati...more >>

I'm using merge replication between sql2000 server and sqlserverce. I'm trying to modify a horizontal filter to include a union. I can't seem to get ti to work. Does anybnody know if it should work? There have been times when I couldn't get a filter to work and I've fooled around with double q...more >>

Hello, I have a scenario where clients enter data into a MSDE local database on their laptop. I would like to add a trigger on that table that fires only on the Server (SQL2K Ent.) when they are synchronizing when a new records has been inserted. By looking at the Merge trigger automaticca...more >>

Hi, i have configure a transactional replica between two server in LAN. The tables that i replicated are a lot of record (15 mil) and there are a lot of operations (insert, update and delate) in source table. I have a big latency from the distribution and the subscription server. The publicatio...more >>

Sql Server SP4 on the publisher/distributer. MSDE SP4 on the subscriber Merge Replication Anonymous Pull Subscriptions TCP/IP only - removed Named Pipes Windows Authent only - removed SQL Server Setup an alias on the subscriber to the publisher. Running on same network but different workgro...more >>

Its fired during SQL Server startup and whats its purpose ? ...more >>

How does updatable subscriptions in transactional replication handle conflicts ? ...more >>

I need some insight as to which replication mode (snapshot, transactional, merge) might be most appropriate for our use. Our topology would be the "central subscriber" with multiple publishers (50+), where the publishers would be located in remote locations. Access to the publishers would ...more >>

Can someone please advise what would be appropriate method when you want to implement the merge replication (Kind of a Real time) between different databases sitting on separate servers. Is Auto Incremental Field which is PK would be a problem when two users try to enter records at same time....more >>

Hi, Big thanks to Hillary for her instructions from May 10 regarding this http://support.microsoft.com/?kbid=886839 article. Unfortunately I’m still doing something wrong :( Last few days I followed Hillary’s steps and after sp_replrestart I got Log Reader running but saying: no repl...more >>

We're using snapshot repl to move tables/data to divisions. Recently, the method of populating the tables on the distributer/publisher changed from TextFile/DTS to DB2/DTS, not very exciting. Now during shapshot build for ONE division (out of 4) we get the following error: Bulk copying sn...more >>

We currently have transactional replication from our ERP system to our datawarehouse. Our ERP system is being upgraded and will have a new database name. I am going to break and recreate replication to our datawarehouse. I would like to change the default database name to be the same as our...more >>

I can't configure my Sql Server 2000 Publisher, the Enterprise Manager reports this error message: "Errore 21007. Cannot add the remote Distributor when it tries to complete the operation. Make sure that the local server is configured as a Publisher at a Distributor". What does it depends on? ...more >>

Today I discovered that the sunbscriptions were missing from my replication setup. I tried to rebuild replication, but when I tried to drop the publications, I received a message saying: SQL Server Enterprise Manager could not create publication 'TFWallChart' from database 'TFWallChart'. ...more >>

We're using snapshot repl to move tables/data to divisions. Recently, the method of populating the tables on the distributer/publisher changed from TextFile/DTS to DB2/DTS, not very exciting. Now during shapshot build for ONE division (out of 4) we get the following error: Bulk copying snaps...more >>

Hello All, I have this model in mind. That is presented below. I am presenting 2 scenarios. Day 1 to day 7, cover scenario 1, and Day 9 covers scenario 2. Day 1. A user subscribes and downloads subscription X. The user works -off line- on his locally cached data Day 5 The same user...more >>

I tried this request on the SQL CE group...but no luck. Can somebody help me out here. I seem to remember hearing/reading somewhere that when performing horizontal partitioning a table using Host_Name in the Where clause and setting the .hostname property of the replication object that the l...more >>

hi we have a very urgend and big problem. we have an sql server 2000 (SP3a) with a master database and several clients with the same database on a local msde (SP3a) for the syncronisation we created a merge publication on the publisher. now we detected a very strange thing. from time to time ...more >>

I've created a snapshot replication between 2 databases on 2 different servers to run once a day. The snapshot has worked but when the distribution job runs it fails within a few seconds. I've looked at the job history and the following error message is recorded: Publication 'EmailDB' is ...more >>

When i do a sp_repldropcolumn, i guess its up to me to drop all the indexes, constraints,etc on the subscribers manually . Is that right ? Even with sp_repladdcolumn, there are a few steps to follow to create.. I first need to run this stored proc and use the @schema_change_script that points ...more >>

Is there any work arounds to replicate a table that has more then 255 columns? TIA, ...more >>

Hello Everyone! We are running two-node active-passive cluster. It failed over this morning, all the services went back up within 20 minutes or so with the exceptions of replication. I couldn't start the log reader agent. In the agent history I only see two events for each session: Starting...more >>

I have created a publication and have 2 articles.. one partitioned horizontally and one partitioned vertically. and upon scripting the publication, i saw 2 sp_articleview calls for these articles. There is a @view_name and I was wondering if those are physical objects created with those names sp...more >>

We have a nightly replication of changes to a database going across the WAN to a server that has been unstable and will be running out of disk space soon. I have a new subscriber set up, and can restore a backup from the old subscriber, so the data will be the same. Due to politics (!), I d...more >>

...more >>

...when they say that merge replication only forwards net data changes and not every transaction ? Doesnt transactional replication not work this way as well ? ...more >>

How does sp_replcounters keep itself updated ? I cant seem to get it refreshing. The replicated transactions for a database is around 8 and is not decreasing althought the log reader agent is running. Do you use it for accurate info to track any issues between the publisher and the distributio...more >>

How do i read this ? Replicated Transaction Information: Oldest distributed LSN : (494721:133301:236) Oldest non-distributed LSN : (494721:133372:1) What are those values ? What should i watch for between the distributed and non distributed LSN ? Which table in the di...more >>