The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
117 views

SQL Server Merge - Pull replication error

I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012. The machine Publisher is a Windows Server 2008 R2 not in windows domain, this Server is also ...
2
votes
0answers
38 views

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file <file-name> due to OS error 2 I have tried setting the security rights for the ...
1
vote
0answers
47 views

Possible to view/edit SQLServer Merge replication queue?

we're experiencing a problem that seems to be blocking the merge process. An old Stored Proc (that has since been removed from the publisher) is trying to run on a subscriber. We've tried ...
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 ...
1
vote
0answers
140 views

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 ...
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 ...
0
votes
1answer
935 views

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 ...
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 ...
0
votes
1answer
331 views

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 ...
0
votes
1answer
371 views

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 ...
1
vote
1answer
367 views

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 ...
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
561 views

Web sync merge replication cannot connect to publisher

Before I start I would like to clarify that I am setting up a test environment to configure & test WebSync before carrying out a deployment at a client. My machines are all running SQL Server ...
1
vote
1answer
282 views

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 ...
0
votes
1answer
208 views

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 ...
6
votes
2answers
363 views

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. ...
3
votes
1answer
511 views

Alter Stored Procedure in SQL Replication

How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication? I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so ...
4
votes
2answers
406 views

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I ...
1
vote
0answers
373 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 ...
3
votes
1answer
1k views

Replication sync failing; Publisher out of Identity ranges

I have Merge Replication set up with a SQL 2005 Publisher/Distributor and roughly 100 SQL 2005 Express Subscribers. Everything was working fine for months and now all of a sudden everyone is getting ...
2
votes
1answer
215 views

SQL Merge Replication - Filter Sets

I have a "working" Replication Set in SQL 2005 that we use in house to our users at remote branches on SQL Express 2005. I want to apply a filter to our biggest Set to help minimize the bandwidth ...
1
vote
1answer
56 views

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 ...
1
vote
1answer
350 views

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 ...
2
votes
2answers
71 views

Merge Partitions Server 2003

I just installed new 500gig drives to replace 160gig drives in my RAID server running Windows 2003 Server. I was wondering if someone could recommend a utility program that would help me recover all ...
1
vote
2answers
960 views

Is Peer-to-Peer replication a replacement for a merge-replication?

please help me in evaluating new possibilities with MS SQL Server 2008. For the last 3 years I have had an MS SQL 2000 Server Merge Replication with a Publisher and two Subscribers on duty, the backup ...
0
votes
3answers
586 views

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 ...
1
vote
1answer
529 views

Merge Replication Publishing Subscriber Scenario

I have a merge publishing subscriber topology of SQL 2008 -> SQL 2000 -> MS Access 2003. In one database at the SQL 2008 level, I have an updateable publication (called catalog) that is unfiltered, ...
0
votes
1answer
753 views

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 ...
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 ...
1
vote
3answers
2k views

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication ...