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

learn more… | top users | synonyms

2
votes
1answer
4k 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 ...
30
votes
4answers
18k 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 ...
7
votes
2answers
862 views

SQL Server : Transactional Replication Computed Column

I am a subscriber to a transactional replication subscription. I have no control over the publisher. I have read the following article about schema changes to the publication database: Make Schema ...
3
votes
2answers
4k 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 ...
2
votes
1answer
95 views

Availability Groups and Transactional Replication

My client has a setup as shown below. AG Group A ---------> Server A (DB--> A) ----> Server B ( DB--> A) Transactional Rep --> Server A ( DB-->A ) ---> Server C ( DB--> B) AG ...
1
vote
1answer
3k views

The process is running and is waiting for a response from the server - transactional replication

I could not yet figure it out why one of my transaction replication subscription is constantly coming out with the following annoying message: The process is running and is waiting for a response ...
0
votes
2answers
1k views

How to restart the distributor agent of transactional replication?

After troubleshooting query time out error I would like to restart my distributor agent. So I go to my distributor server, in my distributor DB (called distribution_SA) I run the following query: ...
6
votes
1answer
2k 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, ...
3
votes
0answers
103 views

How to set ALL the replication to DEADLOCK_PRIORITY LOW?

I have just got this email here: Then looking at the sql server log I find this deadlock was caused by one of our procedures (that was the victim) against the replication. O.K. in this case in ...
3
votes
1answer
901 views

sql server - NoSync subscriptions will need to be dropped and recreated

I am having this error message from the sql server replication monitor: Error messages: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to ...
3
votes
1answer
501 views

Transactional Replication to DB on Same Server instance

We have a SQL Server 2012 instance that contains a database with data for many product lines. We are looking for a way to take subsets of this data into another database on the same instance. This ...
2
votes
2answers
1k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
2k views

Best way to migrate a database involved in bidirectional replication

I have two SQL Server 2005 that are to be migrated to SQL Server 2008 R2. The original pair of servers contain a database that are involved in bidirectional transactional replication between them. In ...
1
vote
0answers
73 views

SQL Server Transactional Replication Distribution Database not keeping up

We have following setup at the moment: 8 Cluster servers (SQL Server 2012 Standard Edition) talking to 2,000 store servers in the field via Merge Replication. The 8 servers are replicating to a ...
1
vote
1answer
484 views

Transaction Replication Without Snapshot

So I have looked up many other people trying to get Transaction Replication Without Snapshot working and I'm stuck. I've followed what everyone has said so I don't know what I'm missing. Prod server ...
0
votes
1answer
934 views

“Uninitialized subscription” on replication monitor when creating a subscription on transactional replication [closed]

we have the same question here. However, that does not answer my question below. I'm using SQL Server 2012 and trying to implement transactional replication. I'm using the system stored procedures to ...
0
votes
0answers
198 views

SQL Server 2012 Replication Subsystem Increase Number of Working Threads

I am trying to create Transaction Replication (Push) between two servers, using a distribution database on a3rd server. Server 1 is SQL Server 2008, Server 2 is SQL Server 2012. The Distribution ...