The automated periodic distribution of transactional changes from a publishing database to one or more subscriber databases.

learn more… | top users | synonyms

1
vote
0answers
77 views

SQL Server replication - recommendations for stability

We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
0
votes
0answers
187 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
2
votes
3answers
3k views

Is replication possible on two different domains?

I am implementing a database replication between different geograhical locations where each one is on a different domain. After going through all the process, when I start the agent it runs and stops. ...
3
votes
2answers
42 views

Is my Publisher database my actual source database or is it a new database?

I am setting up transactional replication for the first time and am working through my backup policies I need to set. Is my Publisher database my actual source database? Or is it a new database that ...
2
votes
2answers
516 views

Dropped the Distibution database before disabling publishing and distribution, how to proceed?

I'm setting up my first Distributor database on SQL Server 2012. I successfully created one and then wanted to blow it away and perform the task again just for practice. This was a brand new ...
0
votes
0answers
190 views

How to move SQL server transaction replication from one server to another server [closed]

Currently we have SQL Server 2005 as a publisher and SQL 2008 R2 as subscriber for one of our database (about 350 GB in size). I want to move the replication to our different server (Which also has ...
1
vote
0answers
74 views

Replication topology advice - central subscriber

I'm seeking guidance and advice about how to set up replication in MSSQL to deal with the following criteria. We have a central server hosted at a data center - this is where our web app is located. ...
2
votes
1answer
106 views

Mysterious missing transactional replication tokens

I am looking at implementing Transactional Replication subscriptions in an AlwaysOn AvailabilityGroup. I tried to use this as a guide: ...
2
votes
1answer
651 views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

We have a group of users within my company that are running reports directly against our production database. It has gotten to the point where they are hammering it enough to cause performance issues ...
3
votes
1answer
178 views

Transactional Replication: can create 52 publication, but creating 53rd leads to problems

My apologies in advance for a long post, but I was really trying to make sure I do my due diligence before turning to the community for help, so here it goes. I am working on a proof of concept with ...
4
votes
1answer
121 views

SQL Server transaction replication ignores DML which does not change data

I have a transactional replication setup between the two servers and I noticed that if a run a statement similar to this: UPDATE mytable SET mycolumn = mycolumn the replication somehow knows to ...
2
votes
2answers
736 views

SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary

We have one way transactional replication enabled on SQL Server 2008 databases. Due to some issues we had to run DBCC checkDB, bringing the database to single user mode. When we complete the DBCC ...
1
vote
1answer
56 views

Changes to main Database during Transactional Replication

Can you please advise how can I keep slave database up to date while it's in transactional replication with master. I mean what If I change indexes, columns, tables or sthm else in master dabase? ...
3
votes
2answers
2k views

transactional replication, failing with communication link failure half way through bcp

I am trying to replicate to a 4th subscriber on a remote site. 3 subscribers work fine locally. the other difference is this is a 2012 subscriber from a 2008 r2 publisher and remote distributor. When ...
2
votes
2answers
998 views

SQL Server Transactional replication failed due to snapshot agent failure

I'm trying to set transactional replication between 2 SQL Server 2012 named instances. I've followed a step by step manual and created a Publication. But once I look into Replication Monitor I Get ...
2
votes
1answer
325 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 ...
17
votes
4answers
7k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
3
votes
1answer
1k views

Creating a read only replica of SQL Server database for reports

I've faced a problem when my .Net web application is running slow, even when I've optimized all queries. As it turned out another developer, who is making reports runs a bunch of non optimized queries ...
1
vote
1answer
142 views

.NET error when trying to create snapshot for transactional Replication

I encountered a bizarre prob today while creating a transactional publication on a SQL 2012 server running on Windows Server 2008R2. I had just had some success creating and initializing some Merge ...
3
votes
2answers
2k views

Why do I get “The initial snapshot for publication is not yet available.”?

We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber. SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
0
votes
1answer
71 views

What happens if you accidentally insert data into a replication target table?

We use transactional replication to replicate data from table1 on server1 to table2 on server2. However, one of my colleagues accidentally inserted some data into table2. In order to keep the two ...
0
votes
0answers
127 views

Adding Massive amount of Articles to existing publication cause screen to hang forever

I am using Win Server 2008 R2 / SQL Server 2008 R2 and i am trying to add about 2K + articles to the existing publication and the screen hangs @ the articles screen. The screen has been there and ...
3
votes
2answers
2k views

Snapshot for transactional replication taking too long for large database

I want to establish a transaction replication of a large database (200GB). But when I create the publisher and the snapshot agent starts, it takes very very long time and it sticks on the following ...
6
votes
1answer
1k views

Replicated Database Log File Maintenance

I have a database on the publisher that is involved in replication (publication configured for merge and transaction). Trying to regain control of the log file for this particular database (VLF count, ...
1
vote
1answer
387 views

Replication is missing a specific set of rows on subscriber

So I've got two servers, we'll call them Server A and Server B. Server A has a table, Table 1, which gets replicated to Server B. Server B has a table, Table 2, which gets replicated to Server A. ...
1
vote
0answers
441 views

Transactional Replication Failing Suddenly - Distributor Error

I have two databases (both SQL Server 2008 R2) taking part in transactional replication. This exists to pass data to a customer of ours, so I am troubleshooting from the Publisher side. Replication ...
0
votes
0answers
705 views

Push Data from MySQL to SQL Server

I am not sure if my title is correct, but I will try my best to explain the current problem. Current Scenario: I have a php web application with MySQL database (let's call it DB1) which is stored ...
2
votes
1answer
1k views

Invalid object name 'master.dbo.MSreplication_options' when restoring DB

I've tried Googling for an answer to this but have got nowhere. I have one SQL Server instance whose replication is set up to be a publisher and a distributor of FooDatabase. I have a second ...
2
votes
1answer
2k views

Transactional replication altering tables and adding stored procedures

I have a database that is replicated in several locations. It is setup as transactional replication. However, now I need to add more columns to the table. Add more stored procedures and etc. Hence, if ...
0
votes
1answer
352 views

Compatibility level for published database and transactional replication

I am running a database on compatibility level 80 because the application using it does not yet support a higher level. It is my understanding that transactional replication on SQL Server 2005 and ...
1
vote
0answers
220 views

Transactional Replication times-out with Database Snapshot on subscription

I have a VLDB that is being replicated using transnational replication. The performance has been terrible, and the process frequently times out. After much investigation, including Service Packs and ...
0
votes
1answer
656 views

Insert missing rows to subscriber of Transactional Replication

I have established SQL Server Replication between SQL Server 2005 and 2008 R2. SQL Server 2005 is the publisher while SQL Server 2008 R2 is the subscriber. The replicated database is about 40GB. ...
4
votes
1answer
3k views

SQL Server 2008 R2 replication high delivery latency

I am seeing an unusually high delivery latency between our distributor and subscribers and i do not understand why. We have in this configuration 3 sql servers using transactional push replication to ...
5
votes
2answers
2k views

Recommended distributor architecture for transactional replication?

We are planning to create a Transactional replication on 2 nodes of SQL Server 2008 R2, each node will be a publisher and a subscriber. What is the best practice in order to have this scenario done? ...
0
votes
0answers
164 views

Data deleted from replicated table

I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription. Couple of days ...
0
votes
1answer
249 views

Restore of Replicated Database fails with “Cannot drop the table <table name> because it is being used for replication.”

published database restoration failed once you setup transactional Replication using system Store procedures. Few work around to this problem is restore with KEEP_replication option and than drop the ...
0
votes
1answer
139 views

distribution.dbo.MSdistribution_history comments explanation

The comment column of distributor.dbo.MSdistribution_history contains comments such as <stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880"> ...
0
votes
1answer
175 views

SQL Server 2005 Transactional Replication

I am in the process of replicating my companies databases from SQL Server 2005 to SQL Server 2012 using Transactional Replication. When complete we will be running preliminary tests on the database, ...
4
votes
2answers
2k views

SQL Server 2008 R2 Transactional Replication “Cannot insert explicit value for identity column…”

Right now I'm having an "identity crisis" with transactional replication in SQL Server 2008 R2. The database is running in compatibility 90. There's a table that has an identity column and won't ...
5
votes
1answer
194 views

Transactional replication creating a fixup index that's sleeping, but blocking other processes

I've just migrated my ERP database server from SQL Server 2000 to SQL Server 2008 R2 (both Enterprise Edition) and that migration went fairly smoothly. However, now that I'm trying to recreate ...
4
votes
2answers
1k views

Transactional Replication Concerns

We are debating an architecture that employs sql server 2012 and transaction replication. Idea is to offload reporting activity to a secondary server and have the ability to include/exclude what is ...
0
votes
1answer
57 views

Subscriber database to be in sync using Distributor

I have database D1 as a publisher, D2 as a subscriber and they are using Distributor 'DIST' which is reside on the subscriber side. Both D1 and D2 database having DR databases called DR1 and DR2. I ...
2
votes
2answers
581 views

Bandwidth comparison between log shipping and transactional replication

Which technique uses more network bandwidth: Log shipping Transactional Replication Can some one share any benchmarks for the same ? What would be the Memory and I/O impact on the Primary server ...
-1
votes
2answers
547 views

Restore Replicated Database on Different Server

I want to Restore the replicated database on different server and resume the replication from there. I have distributor and subscriber running on the same server. when i restore my replicated database ...
3
votes
2answers
558 views

Cleaning up transaction replication del/ins/upd stored procedures?

I'm referring to the ones that start with: dbo.sp_MSdel... dbo.sp_MSins... dbo.sp_MSupd... I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
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 ...
1
vote
1answer
648 views

Snapshot not picking up new articles in SQL Server 2012 transaction replication when added through script

I am trying to add new articles to an existing publication in SQL Server 2012. I am adding the article to the publication with the syntax --add the table into the correct publication sp_addarticle ...
4
votes
1answer
666 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 ...
3
votes
1answer
537 views

Cannot delete publication

When attempting to delete a publication, I am getting the error cannot drop publication 'XX' cannot drop article 'XX'. The subscription has been deleted at the subscriber. Any ideas on how I can ...
5
votes
1answer
869 views

Transactional Replication not sending all commands

I have a transactional replication topology as follows: NY Publication Database same server holds distributor NY - Subscriber LON - Subscriber HK - Subscriber We are using bog standard, one-way ...