One of the three replication method in SQL server .Merge replication is typically used in server-to-client environments.
7
votes
1answer
121 views
Estimated versus actual query plan with function calls
I have this query on SQL server, a merge replication query:
SELECT DISTINCT
b.tablenick,
b.rowguid,
c.generation,
sys.fn_MSgeneration_downloadonly
(
c.generation,
...
7
votes
1answer
325 views
SQL Server distribution database log file grows uncontrollably after full database backup
We have a merge replication environment that is pushing to 8 subscribers. This is working fine. Our distribution database is setup in Simple recovery mode. We have a maintenance plan that will backup ...
7
votes
1answer
202 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 ...
6
votes
2answers
453 views
Working Around Filtering Problems in Merge Replication
I am in the process of defining filters on a merge replication publication for our database.
The problem I am coming up against is that merge replication has these rules, I don't like to call them ...
6
votes
1answer
721 views
Upgrade SQL Server 2005 to SQL Server 2012
I have a test environment set up with the following:
Virtual Machine (Hyper-V)
Windows Server 2008 R2 SP1(x64-bit)
Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
1 ...
5
votes
3answers
183 views
What type of SQL Server Replication fits our scenario? Merge or Transactional?
Background
In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
5
votes
1answer
256 views
Deadlock on Merge replication
I'm having a really confusing problem on the msmerge_contents table on some
of my merge replication databases. It seems I'm receiving a dead lock on the exact
same row on the same index on the table ...
4
votes
1answer
129 views
The issue of sp_MScheckIsPubOfSub stored procedure
We have SQL Server 2008 R2 Merge replication set up.
We have 20+ push subscriptions.
Once in a while I get the following error message during the sync:
Error messages: The merge process could not ...
4
votes
1answer
71 views
How to reinsert corrected rows from the conflict table?
I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
3
votes
1answer
86 views
The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber.
When syncing a SQL Server 2008 subscriber with a publisher, the sync fails at around 98% with this error message:
The Merge Agent failed because the schema of the article at the Publisher does not ...
3
votes
1answer
116 views
Merge replication with PDAs AND P2P replication between servers?
We're currently building a setup to scan tickets at an event. We plan on having 2 servers at each entrance but can't have a local link between the two.
We have scanners (sqlCE) and half of them are ...
3
votes
1answer
83 views
Is there a way to start a script on the publisher when synchronization starts?
I am using merge replication with pull subscriptions and Web Sync.
What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process?
...
3
votes
1answer
75 views
How to update conflict resolver when upgrading from SQL-Server 2005 to SQL-Server 2008
We have recently upgraded from SQL Server 2005 to SQL Server 2008 (R2, SP1). This upgrade included some publications, where all tables are published with a default conflict resolver based on the ...
3
votes
1answer
124 views
Transactional versus Merge Replication (Restore backup after downtime)
I have the following transactional replication setup:
Windows Server 2008 with SQL Server 2008 Enterprise
Server A: Master, has a database with a table, publisher
Server B: Slave, subscriber ...
3
votes
0answers
98 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 ...
3
votes
0answers
85 views
Uninitialized Merge replication subscription
I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the ...
3
votes
0answers
70 views
Multiple Merge Replications on same SQL Server Database Conflicts
I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...
3
votes
0answers
158 views
SQL Server 2008 R2 - Merge Replication - Can the Distribution Database size cause replication problems?
Setup:
We have a SQL Server 2008 R2 instance running on a central server.
The server is a merge-replication publisher.
We have 'N' subsribers running SQL Server 2008 Express. 'N' can grow to any ...
3
votes
0answers
60 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
2
votes
1answer
183 views
Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber
is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
2
votes
3answers
328 views
Table with identity column in merge replication
I have a table in SQL Server 2005 and I have an IDENTITY(1,1) property set for an ID column. Records are inserted in a table at a local server as well as a remote server. I am using Merge ...
2
votes
2answers
192 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
votes
2answers
24 views
Querying number of subscription to each publication
We have a production box that has about 60 publications on it. Some of these are used, and some seem to not be... What I need to do is create, or find, a script that will get the count of ...
2
votes
1answer
69 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 ...
2
votes
1answer
227 views
Merge Replication: Where are rowguids of conflict losers stored?
I'm trying to obtain the row guid of all the merge replication conflict losers listed in my conflict viewer. The bug that was allowing the conflicts to occur has been identified and resolved but now ...
2
votes
2answers
258 views
How To Set Up Web Synchronisation With IIS 7.5
I set up merge replication web sync using a pull subscription.
When I try to start the merge agent at the client side I get this error,
The Merge Agent could not connect to the URL
...
2
votes
2answers
344 views
Oneway sync of two SQL Servers via FTP
I need to replicate data from a ‘master’ SQL Server out to a number of replicas. Luckily the data only flows from the ‘master’ to the replicas.
I need to replicate both schema and data. Data size ...
2
votes
1answer
103 views
How can I modify a trigger at subscribers SQL Server 2005?
I have a SQL Server 2005 publisher with SQL Server 2005 subscribers and one SQL Server 2000 subscriber running merge replication.
Is there any way to modify triggers at a subscriber with the ...
2
votes
1answer
147 views
Why would “Drop Database” fail on local SQL Server 2005 Express instance?
I am trying to run the below code. It works for me but not for at least some of my users it doesn't work. It doesn't seem to error just no actually remove the DB's.
string sqlConnectionString=@"Data ...
2
votes
1answer
155 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 ...
2
votes
0answers
48 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 ...
2
votes
0answers
52 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 ...
2
votes
1answer
93 views
SQL Merge Replication: Cannot resolve conflict
I have a SQL Merge Replication over HTTP (Replisapi.dll). I'm not very familiar with the internas of the replication conflict solving because it was always working so far.
Now I have two conflicts in ...
2
votes
0answers
48 views
How To Diagnose Slow sp_mssetupbelongs
I am using merge replication with SQL 2012.
When performing a clean sync using the merge agent I am getting a timeout on this stored procedure,
sp_mssetupbelongs
I am wondering what the best way to ...
2
votes
0answers
44 views
MSMerge_contents Table Populated After One Sync
I am running merge replication with SQL 2012.
When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF.
When I run ...
2
votes
0answers
65 views
Identifying connection and publisher vs subscriber in merge replication scheme
We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
2
votes
0answers
56 views
Merge Replication Optimization
I am running Merge Replication on Microsoft SQL Server 2012 through web sync.
Is there a way to recognize when regenerating a new snapshot and applying it would be more efficient than running a ...
2
votes
0answers
129 views
How to Rename Table or Field With Merge Replication
I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field.
These operations are not permitted in merge replication.
However I can think of an ...
2
votes
1answer
37 views
What else does sp_addmergefilter do
I am running the following stored procedure to add a merge replication join filter,
sp_addmergefilter
What else does that stored procedure do behind the scenes?
I am calling that stored procedure ...
1
vote
1answer
118 views
SQL Server Merge Replication, Agent Batch Size
Is there anyway to increase the merge agent batch size after the publication is created?
I know DownloadGenerationsPerBatch flag when creating a new Publication, however what I'm looking for is a way ...
1
vote
2answers
161 views
Merge Replicate and Mirrors
I am preparing some scripts to setup merge replication in our production environment.
After completing the export from UAT, I've come across something that doesn't appear like it would work in the ...
1
vote
1answer
102 views
Locking And Blocking With Merge Replication
I am using merge replication in SQL 2012 with web sync.
When I insert records into the top tables in my filter hierarchy it causes a lot of locking on the tables, including the merge replication ...
1
vote
2answers
224 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)
...
1
vote
1answer
90 views
Merge Replication Snapshot Files
I am using Merge Replication with SQL 2012. I look in the snapshot directory, but the largest file in there is a prc file which is 646 KB.
I know for sure that the biggest of my replicated tables is ...
1
vote
1answer
121 views
SQL Server 2005 merge replication failure
We have a customer who, when trying to sync a client (subscriber) to the server (publisher,) receives the following error:
2012-11-30 21:03:33.334 Percent Complete: 18
2012-11-30 21:03:33.334 Data ...
1
vote
1answer
36 views
Merge Replicate, reinitialise with a different part of the data
I have a set of database with merge replicate configured between them.
The publisher is an aggregate of three sets of data.
Call them set 0, 1, and 2
There are subscribers that grab one set of the ...
1
vote
1answer
96 views
How Can I Isolate A Merge Replication Timeout
I am using merge replication in SQL 2012 with web sync.
When I create my subscription I am getting a timeout. The error message is not clear about cause of the timeout, but what I do know is if I ...
1
vote
2answers
44 views
Does sp_addtabletocontents Use Precomputed Partitions
I am using merge replication in SQL 2012.
When I bulk insert rows into a table, and run this stored procedure to add references into the merge tracking table,
sp_addtabletocontents
Is that missing ...
1
vote
1answer
116 views
Why Regenerate Snapshots For Merge Replication
I am in the process of implementing merge replication in SQL 2012 with web sync.
I am wondering two things,
Why is it suggested to regenerate the snapshots every 14 days by
default?
With web sync ...
1
vote
1answer
70 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 ...
