Questions tagged [merge-replication]
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.
11
questions
13
votes
3
answers
26k
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?
- 16.4k
10
votes
3
answers
2k
views
Hard limitation for merge replication article count?
A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
- 201
7
votes
1
answer
4k
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, ...
user507
3
votes
1
answer
430
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:
...
- 31
10
votes
3
answers
4k
views
PK as ROWGUIDCOL or use a separate rowguid column?
There's a long-winded debate going on here so I'd like to hear other opinions.
I have many tables with uniqueidentifier clustered PK. Whether this is a good idea is out of scope here (and it's not ...
- 11.3k
5
votes
2
answers
2k
views
Replicating a Table Structure With no Data Using Merge Replication
I am using merge replication with SQL 2012.
I have a table, and it would be useful to propogate that table to the subscribers, but just the table structure, not the actual data.
The data in the ...
- 2,187
3
votes
2
answers
2k
views
What is the Maximum Merge Articles in Merge Replication [duplicate]
Possible Duplicate:
Hard limitation for merge replication article count?
I am using merge replication in SQL 2012. I am looking here:
Maximum Capacity Specifications for SQL Server (2012)
...
- 2,187
3
votes
4
answers
3k
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 ...
Paul Joicey
1
vote
1
answer
340
views
How Merge Replication Works
I'm not DBA at all but I need to do something to synchronize four SQL server databases. I just discover there is a Merge Replication system in SQL Server 2008. At this moment I'm reading the ...
- 163
1
vote
1
answer
2k
views
How to troubleshoot SQL Server Merge Replication Conflict?
I have SQL Server 2008 R2 Merge Replication setup.
I have 2 publications for the same database with 20+ subscribers.
The logic of our application prevents changing the same data from 2 subscribers ...
- 663
0
votes
1
answer
119
views
Merge subscription behaviour
I have a merge subscription with the ExchangeType parameter set to 1 (upload only).
Rows are transferred to the publisher as expected.
If I delete a row at the subscriber, the corresponding row at ...
- 11.3k