A type of replication in SQL Server in which Publishers and Subscribers can work autonomously and later reconnect, synchronize, and merge data changes to achieve convergence among all nodes in the topology. Merge replication is typically used in server-to-client environments.

learn more… | top users | synonyms

0
votes
0answers
11 views

What is “Set the merge agent on the problem subscribers to use the slow link agent profile”

I have never used Merge Replication Feature of the sql server before, so What does "Set the merge agent on the problem subscribers to use the slow link agent profile" mean? Background info: "Merge ...
1
vote
0answers
11 views

Merge Replication: Updates to Schema

We have a main SQL Server which replicates to two backup servers via continuous merge replication. There are regular updates to the schema. Regular changes include: Adding new tables and ...
1
vote
1answer
430 views

How to user the Tablediff Utility with Replication Filters

I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence. I see a problem with this approach though. This is because I am using parameterised filters to ...
1
vote
1answer
227 views

SQL Server replication conflicts after migration from 2000 to 2008

I got a suggestion over at Stackoverflow to post here....greatful for any and all help. Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
3
votes
1answer
198 views

List of Expired Merge Subscribers

I have a setup of merge replication. Sometimes, subscribers will not be able to sync within the retention period set in the publication. How can I get a list of expired subscribers to a merge ...
1
vote
1answer
105 views

How to tell what user has synced

I have set up merge replication web sync to sync a publication from a SQL Server 2012 database. I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME(). When I do a sync is ...
2
votes
2answers
2k views

SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers

We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
0
votes
3answers
897 views

Merge Replication identity field issues

One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
1
vote
1answer
56 views

Replication Monitor Information using T-SQL

The image below shows a transaction replication problem that I am currently investigating. The image comes from the Replication Monitor. How can I get this information using T-SQL?
0
votes
0answers
37 views

Saving replication latency for monitoring purposes

I have SQL Server 2012 Enterprise edition, transactional replication. many servers, many DBs. This morning I come to the office and been told the latency on some databases was about 30 min behind. I ...
0
votes
0answers
22 views

Add/remove tables in merge replication without full snapshot

I have a laboratory system that need to be installed in different collection stations, each with a independent database installation, but synchronizing some data among them, such as tests results, ...
0
votes
1answer
291 views

SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent

I am trying to create replication subscriptions to and SQL Server 2008 R2 via a script. There are 3 subscribers so this script creates the subscriptions by calling sp_addmergesubscription and then ...
0
votes
1answer
688 views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...
1
vote
1answer
265 views

Syncronize mysql databases between local and hosted servers automatically

We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
34 views

Automating SQL Server Merge Replication Processes [closed]

Hi all is there anyway I can automate the entire process of the Merge Replication?
0
votes
1answer
30 views

The message “Running the Merge Agent process would exceed the maximum number of processes allowed” appears, but it doesn't seem likely

The full text of the message is "Running the Merge Agent process at this time would exceed the maximum number of processes allowed by this publication. The process will run when resources become ...
2
votes
0answers
24 views

Replication stopped working, no errors

I have a TOP server (SQL Server 2012) with a merge replication to around 4 other servers. When I subscribe to the publication, everything is downloaded fine to the subscriber. The insert of one of ...
0
votes
1answer
35 views

SQL Server 2012 Replication, how to ignore action with specific trigger?

SQL Server 2012. Database is in merge replication, no conflicts presented. Current example is simply for understanding, but real schema is very huge to describe. Schema and trigger at SQLFiddle for ...
0
votes
0answers
25 views

Database Read Only after Merge Replication

Win Server 2012, SQL Server 2012 Std. I have a previously accessible database with which I'm testing merge replication and after I publish the DB, my application is saying the DB does not have write ...
0
votes
1answer
17 views

I couldn't see Conflict tables in replication monitor SQL Server 2008 R2 in Merge Replication

I work with merge replication in SQL Server 2008 R2. In the replication monitor I can't see conflict table, I must to see conflict tables in "MSmerge_conflicts_info", please help me. How to see ...
5
votes
2answers
314 views

Why Do Replication Deletes Require sysadmin Access

I am running merge replication with SQL 2012. There seems to be a nasty consequence of the delete triggers added for replication in SQL 2012. Inside the delete triggers are this, select @xe_message ...
0
votes
1answer
22 views

MSSQL 2000 replication, incrementing an integer column on a single row using an update statement

I have 2 web servers, both of which connect to separate mssql 2000 database servers, these two servers use merge replication in order to collate tracking data. Now each web server runs an update ...
1
vote
1answer
64 views

Replication consistently fails to bring new rows to subscriber

Short description of the problem: Initial synchronisation to the subscriber works fine. Subsequent synchronisations fail to download new rows. Re-initialising the subscription "fixes" the issue and ...
1
vote
0answers
79 views

The replication Merge Agent failed to propagate a Publisher schema change to the Subscriber

We are running 2 Microsoft SQL Servers - publisher (2008R2) / subscriber (2008 Express) with merge replication. I tried to make some schema changes via Transact-SQL and partly failed. So tried to ...
0
votes
1answer
45 views

Merge Replication API with SQL Server 2012 / 2014

We are using SQL Server 2008 with merge replication. Our business application uses the rmo api, which we have installed with SQL Server Feature Pack 2008 SP3 and there the package sql_rmo.msi. Now we ...
0
votes
0answers
80 views

Merge Replication — Reinitialize Without Recreation

I have a publication with ~10 subscriptions configured as clients. They all have a partition of that data using row filters. Earlier this week I received this error on two of the subscriptions: ...
0
votes
0answers
13 views

How to back out of mass update in SQL Replication [duplicate]

We have a database which is set up in Merge Replication. We accidentally updated hundreds of thousands of records in a large published table on the publisher database. We did is something like ...
2
votes
1answer
75 views

How to back out of mass update in SQL Replication

We have a database which is set up in Merge Replication. We accidentally updated hundreds of thousands of records in a large published table on the publisher database. We did something like this: ...
1
vote
1answer
30 views

Restarting a Publisher involved in Merge replication

Our hosting provider would like restart the SQL Server that a publisher in a merge replication topology. I'm not able to clearly understand best practice for doing this from the Microsoft docs. Our ...
0
votes
1answer
39 views

Merge Replication - Merge initial data contained on subscriber

I have two identically structured databases on two separate servers. Both have different data within them. I have set one of them up with merge replication as a publisher and I want the other to be ...
0
votes
1answer
84 views

SQL Server Merge Replication Change Partition Definition

I am using Merge Replication on a few SQL Server 2008 R2 servers. There is one server, and the rest are clients. I have each of the clients on a different partition using row filters with the ...
3
votes
1answer
102 views

How can we achive the replica of databases for SQL Server?

I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server. In the ...
0
votes
1answer
38 views

Merge replication parameterised filters

We are looking at using merge replication to maintain a 2-way data flow between a central SQL Server 2012 Standard database and, eventually, 100's of international satellite SQL Express 2012 ...
1
vote
1answer
368 views

Snapshot agent stuck at 48%

We are having to redo a publication/subscription and while running the snapshot agent it stalls at 48% with the message "The process is running and is waiting on a response from the server." ...
0
votes
0answers
74 views

SQL Server 2012 Replication Initialisation Fails — Table keeps being dropped

I have two servers - one located in Australia (Distributor / Publisher), and a second in the UK (Subscriber) both on Amazon's cloud. I have attempted to configure replication as both pull and push ...
1
vote
4answers
114 views

Backup from Server1 and restore it to Server2?

IF we have two Servers installed with SQL Server 2008 instances, Server1 has three drives C, D and E with 100, 500 and 500 GB respectively and Server2 has three drives C, D and E with 100, 300 and ...
2
votes
1answer
126 views

SQL Server Merge Replication Dummy Update issue

We have SQL Server 2005 SP4, using merge replication. We started getting this error when the subscribers try to replicate (not all of them but most): The process could not deliver dummy update ...
2
votes
1answer
409 views

How does merge replication work with SQL Server CE

I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE? For instance merge replication with SQL Server databases ...
3
votes
0answers
151 views

merge replication too big

I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database. for some reasons I keep the old data in the databse and set ...
1
vote
2answers
125 views

For merge replication, do I need to schedule index maintenance on all sites or just publisher?

I have a very fragmented database that uses merge replication with remote sites. Do I need to schedule index maintenance (reorganize / rebuild) for all sites? Or just on publisher copy?
0
votes
0answers
41 views

Subscription uploading is not happening every time

I have two SQL Servers (2008 R2), and merge replication between them, one being the publisher and the other subscriber. I noticed that downloads are happening every minute, but uploads are happening ...
1
vote
1answer
438 views

Mysterious merge replication problems creating a subscription

We have a merge publication which had been mostly working OK for a long time (years). Recently an article was added, we were informed the snapshot was out of date, so we regenerated it. Then we got ...
6
votes
1answer
1k views

Replicated Database Log File Maintenance

I have a database on the publisher that is involved in replication (publication configured for merge and transaction). Trying to regain control of the log file for this particular database (VLF count, ...
1
vote
0answers
114 views

Row not being deleted from the publication when it's deleted in a subscription

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
0
votes
0answers
180 views

SQL Server Merge Replication Stuck, lots of conflicts and genstatus = 4 (interrupted) [closed]

Merge replication is the gift that keeps on giving as far as throwing new things at us, and the latest is a subscription that had been behaving for quite sometime suddenly slowing to a crawl. This ...
1
vote
2answers
222 views

Install SP 3 on SQL Server 2008, where merge replication is running

I have a SQL Server 2008 and I should install Service Pack 3 for it. On my server there are several databases replicated, and mobile devices sync data via merge replication. Can problems occur, if I ...
3
votes
1answer
212 views

How to replicate from SQL Server 2000 to SQL Server 2008 R2?

I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber. I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine. Primary key fields are not ...
2
votes
1answer
124 views

Merge replication issue : conflicts with new data

I set up merge replication with SQL Server 2008, I am having issues when creating new data on clients and trying to synchronize with the remote server. Pulling data from the server works fine. But ...
1
vote
0answers
417 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
0
votes
2answers
287 views

“an agent job has not been created for this subscription”

I have set up merge replication with a publisher on my SQL Server 2008 R2 box with the distributor on this box too; in Express I have created a subscriber but the subscriber won't run because of the ...