The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
33 views

MSSQL 2000 replication, incrementing an integer column on a single row using an update statement [migrated]

I have 2 web servers, both of which connect to separate mssql 2000 database servers, these two servers use merge replication in order to collate tracking data. Now each web server runs an update ...
0
votes
1answer
152 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
41 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
49 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
68 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
2k 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
149 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
575 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
1k 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
293 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
398 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
430 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
421 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
86 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
607 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
298 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
209 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
550 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
419 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
404 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
218 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
355 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
72 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
1k 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
614 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
539 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
845 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
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 ...