1
vote
1answer
64 views

Merge Publication Data Partition Snapshot generation

I have a merge publication in SQL 2008 R2 with data partitions and I am wondering when I should generate the snapshots for the data partitions. I get an error sometimes when bringing a new subscribe ...
1
vote
0answers
1k views

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 ...
4
votes
1answer
458 views

Limitations in SQL Server merge replication - Publication to number of subs

I'm looking for a couple different things here. From what I can find, Workgroup edition supports up to 25 subscribers per publication. Does anyone know the limit, if there is one, to the number of ...
1
vote
1answer
267 views

SQL Server 2008 Chaining Merge Replication

Is there a way to have multiple "tiers" for a merge replication in SQL Server 2008. For example I have SiteA with SQL Server 2008 that has a publication setup on TestDB. SiteB, also with SQL Server ...
2
votes
1answer
82 views

Problems with merge replication

We are developing a multi-user desktop application with users located in different countries. The platform is - .net 3.5, SQL Server 2008, WinForms. Now, my client has used the help of a DBA who has ...
1
vote
0answers
372 views

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 ...
1
vote
0answers
57 views

Can/Should I have Replication Schema on databases that don't participate in replication?

I'm dealing with several databases, some of which will participate in replication, others will not. Is it possible (or wise) to keep the replication schema on the database that do not participate in ...