Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [merge-replication]

29 questions
1
vote
0 answers

Unable to authenticate proxy when starting SQL snapshot agent

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync working with merge subscriptions. However when I…
Myles Gray
  • 659
  • 4
  • 12
  • 33
1
vote
0 answers

Identity Range Management problem

Recently upgraded from SQL Server 2000 to 2008. When we recreated the Merge Replication we decided to use Automatic Identity Range Management (since it is now the default in 2008). The problem is that we keep running out of ID ranges on the…
mwolfe02
  • 193
  • 1
  • 1
  • 12
1
vote
1 answer

How do I increase the -QueryTimeOut parameter in MS SQL 2008?

I have two servers running Microsoft SQL 2008 and I am using Merge replication. It uses a push subscription. The other day there was an event that would have caused more rows to be inserted into the database then normal. Between 5,000 and 10,000…
Jason Lamoreux
  • 109
  • 1
  • 10
1
vote
1 answer

Windows DFS-R conflict handling between multiple locations

i´m experimenting with the DFS-Replication possibilities in Windows Server 2008 R2. Basic structure is this TestOffice 1 - Fileserver TestOffice 2 - Fileserver Central server location - Fileserver The three fileservers replicate their data…
John K.
  • 11
  • 2
1
vote
1 answer

Trouble with Identity Range Sizes

I am trying to setup our replication with a republisher. We, unfortunately, have some tables with an int PK IDENTITY and I am getting the following error when trying to create the publication. SQL Server Management Studio could not create article…
Refracted Paladin
  • 345
  • 7
  • 20
1
vote
1 answer

SQL server 2000, replication over WAN

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances. They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to connection them through remote-SQL so they appear in…
BerggreenDK
  • 188
  • 9
1
vote
0 answers

Error while starting synchronize

I'm using merge replication for database synchronization. I'm getting the folllowing error when launching the replication monitor.I can able to access both sides. Stil having the problem. Error messages: The process could not connect to…
Developer404
  • 155
  • 1
  • 1
  • 9
1
vote
1 answer

Filtering Replication Sets for Top 2

I have a Replication Set that we use in Merge Replication(SQL 2005). I am trying to figure out how to apply a Filter of Top 2 to a table. Also, is there a way to set up a Filter so that it trickles down to sub-tables or would I need to handle that…
Refracted Paladin
  • 345
  • 7
  • 20
1
vote
1 answer

SQL Server 2005 Merge Replication to SQL Server CE 3.5

In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact…
None
0
votes
3 answers

SQL Merge Replication - Compress Snapshot

I have Merge Replication set up at our company with a central SQL 2005 as the Publisher/Distributor and the clients are all SQL 2005 Express. In our remote branches we are having difficulty with the initial sync time. The database is ~2GB and is…
Refracted Paladin
  • 345
  • 7
  • 20
0
votes
1 answer

Slow merge replication over a WAN link - only downloads

We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of data we are synchronising has increased a lot this…
Mark E
  • 1
0
votes
1 answer

Merge Replication: I dropped a table and now I can't reinitialize

I have a SQL 2005 Standard*(Publisher/Distributor)* to SQL 2005 Express*(subscriber)* Replication Topology. I deleted(thru SSMS) a table and added a row to a different table. I then ReInitialized All with a Generate New Snapshot option and then…
Refracted Paladin
  • 345
  • 7
  • 20
0
votes
1 answer

Replication Publication Configuration

When trying to configure a publication I get the below error. SQL Server could not configure 'MyServer' as a Distributor. ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch.…
user42937
  • 113
  • 6
0
votes
1 answer

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say --> /* Missing Index…
Refracted Paladin
  • 345
  • 7
  • 20
1
2