2
votes
2answers
61 views

Replication between SQL Server 2005 - 2005

I'm hoping to get some help with a SQL Server 2005 replication issue. In short, in replication monitor, (On the Publisher), on the 'Distributor to Subscriber History' tab, I see two lines under ...
2
votes
1answer
100 views

SQL Server Merge Replication Dummy Update issue

We have SQL Server 2005 SP4, using merge replication. We started getting this error when the subscribers try to replicate (not all of them but most): The process could not deliver dummy update ...
2
votes
1answer
214 views

Double queue reader or is it still busy?

I came across this line in the verbose log on replication QueueReader Agent job startup. The Queue Reader Agent has encountered the error 'Another queuereader agent for the subscription or ...
0
votes
1answer
471 views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...
1
vote
1answer
251 views

Mysterious merge replication problems creating a subscription

We have a merge publication which had been mostly working OK for a long time (years). Recently an article was added, we were informed the snapshot was out of date, so we regenerated it. Then we got ...
5
votes
3answers
1k 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 ...
4
votes
1answer
324 views

SQL Server 2005 Replication

I am in the process of creating Replication between 2 Remote Servers, server 1 is the Distributor and Publisher and server 2 is the Subscription. server 1 windows 2003 server 192.168.10.1 connected ...
4
votes
1answer
500 views

Replication between SQL Server 2005 and Azure database

Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database? My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of ...
8
votes
1answer
3k 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 ...
4
votes
1answer
1k views

How to restore replication after server crash

We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor. Then the RAID on the ...
3
votes
1answer
254 views

Restrict record to be update or deleted according to dates inside row for SQL Server 2005

I have transaction replication between two SQL Servers. For testing purposes I deleted a lot of records at the subscriber that still existed at the publisher. I now know that if someone updates, ...
0
votes
2answers
289 views

SQL Server 2005 replication for a data warehouse

We are trying to implement some kind of Data Warehouse at my current employer. Most of our data is in a SQL Server 2005, but we might also integrate some Access databases and some databases in a SQL ...
2
votes
3answers
1k 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 ...
7
votes
2answers
2k views

Impact of changing the DB compatibility level for a Published replicated DB from 90 to 100

I have a SQL Server 2008 R2 server with a bunch of published databases that are currently operating under compatibility level 90 (2005). The subscription databases are also SQL Server 2008 R2, ...
1
vote
1answer
135 views

SQL 2005 Replication Create/Delete Tables, Views, and Procs

I have replication setup on a couple SQL2005 servers. According to http://msdn.microsoft.com/en-us/library/ms151870(v=sql.105).aspx replication works when changing an item. How do I have ...
1
vote
1answer
218 views

SQL 2005 Replication - How do I get the DA Profile MaxBCP option to work with a Transactional Publication?

I have two publications on a database. One is a transactional publication, the other is a snapshot publication. We have a stand-alone Distributor (separate from the publisher) and both publications ...
7
votes
3answers
181 views

How to handle reporting of an extreme amount of databases in SQL Server 2005?

I'm looking for some advice on how to handle reporting for our environment. We currently have 16 servers with 20 instances of SQL Server 2005. We have over 6,600 databases and growing across these ...
5
votes
1answer
95 views

Autogrowth and Merge Replication

We are using Merge Replication with SQL 2005. It seems I need to change the Autogrowth settings on the Publisher but I am wondering what the impact is to Replication. Will it force an Initialization? ...
1
vote
1answer
340 views

SQL Server Merge Replication - Safely shrink transaction log

I have a couple of SQL databases running in merge replication. My publishers HDD is full due to the transaction log of the database being replicated which is causing my snapshot agent to fail (out of ...
4
votes
1answer
88 views

Has Replication Stalled?

What Happened: I reinitialized a subscription 16 hours ago. I had about 1.2M records to transfer, so I was expecting it to take a while. The Replication Monitor was saying "N transactions with N ...
3
votes
2answers
262 views

Reinitializing Subscription Performance

I have 4 Servers, Servers A, B, C, D. Server A publishes a Replication instance, and Servers B, C, D have Pull Subscriptions to it. Server B's subscription needs to be Reinitialized, but I am ...
6
votes
2answers
1k views

Out-of-sync Replication in Sql Server

Okay, a little complex: One local DB table is being replicated to another local DB with same table. Worked for years. User account on replication job is gone, so job was failing. I updated it to a ...
1
vote
2answers
1k views

Transactional Replication - table does not have the identity property

I have a one way transactional replication set up between two 2005 MS Sql servers. Recently I have started to receive the following message in the replication monitor from the subscriber: Table ...
0
votes
1answer
54 views

Start Windows Service If Replication Fails

Setup: We have SQL Server Management Studio 2005 SP3 on all of our Servers. We have 1 Main Server, and 1 Secondary Server that has the database from the Main Server being replicated on it. (If it ...
1
vote
2answers
171 views

What's the best way to ensure referential integrity on a replicated database?

Using SQL SERVER 2005, I have a couple of questions on Replication and referential integrity. 1) Does Replication handle referential integrity? 2) If I do an Insert to Parent table and then to ...
1
vote
1answer
2k views

How to move data from Primary Data File to other data file without destroying replication

I have one Database which is replicated using transactional replication. Now, I want do spare some data of that database to another partition, because my server running out of disk space. I was ...
6
votes
1answer
159 views

Replication problems after server upgrade

In transactional replication - first 8000 rows of snapshot copies to subscriber snapshot then acts like it completed successfully. Publication table has 21 million rows. Snapshot says completed ...
2
votes
1answer
402 views

How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?

I'm trying to figure out how often to back up the distribution database when "sync with backup" is set to true. If I understand this correctly, sync with backup ensures the distribution database can ...
4
votes
2answers
609 views

sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?

Scenario We have an existing table in 3 different publications (going to 3 different subscribers), 1 of those publications does not publish all columns. All of these are transactional pull ...
2
votes
1answer
485 views

How to add another table to publisher and subscriber without reinitializing the subscriber?

Is there chance to add another table in SQL Server 2005 transactional replication without reinitializing subscriber. Thanx.
2
votes
2answers
538 views

SQL Server Replication Agent Profile -Output Parameter

I'm trying to add the -Output parameter to my log reader agent for transactional replication and getting this error: Msg 21805, Level 16, State 1, Procedure sp_MSvalidate_agent_parameter, Line 92 The ...
2
votes
1answer
642 views

Are master/slave replication relationship between different versions of SQL Server possible?

I have a database server, SQL Server 2005, that's inside a private network. Now i need to make a database there available for a webserver, so i want to replicate this db to an external server, which ...
5
votes
1answer
425 views

What are the common reasons for a Subscription to be deactivated in SQL Server 2005?

I am trying to manage database replication in SQL Server 2005. I have set up my publications, distributors and subscriptions and it seems to work properly at the start. However, after a period of ...
4
votes
2answers
1k views

Can I have different publishers and one subscriber in replication?

I have the same databases in three cities which each database have three tables: 1- tbl_worker 2-tbl_workshop 3-tbl_users and cities are:city1,city2,city3 city2 and city3 insert informations in ...