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

learn more… | top users | synonyms

1
vote
3answers
207 views

Replication taking too much time between requests

We are using transactional replication in SQL Server 2014 with one master (publisher), 1 distributor (dedicated server), and 3 slaves (subscribers). All writes are made to master and reading is done ...
0
votes
1answer
57 views

SQL Server distributor server move

I need to move my distributor server to a brand new server without resnapshotting it. The scenario I have is similar to the one defined in below link. ...
1
vote
4answers
84 views

Execute a script after transactional replication setup completes

We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute ".SQL File" at subscriber database. Please help on this. ...
0
votes
0answers
12 views

Incremental snapshot in transactional replication [duplicate]

Is there a way to increment the snapshot at the distributor instead of reinitalizing the snapshot every time a new table is added/removed/altered? It is taking a lot of time to generate the snapshot. ...
3
votes
1answer
63 views

What about redundancy if distributor goes down?

I'm setting up load balancing, transactional replication and mirroring. However, what I actually thought might work from the beginning, making the system redudant doesn't actually work because a ...
0
votes
0answers
33 views

SQL Server : distribution agent error

In my transactional replication setup, the replication monitor keeps printing this message every 5 mins: Agent XYZ is retrying after an error. 35 retries attempted. See agent job history in the ...
3
votes
2answers
136 views

How to wait for SQL Server replication reinitialization via TSQL

We use transaction and push replication. Every night after the data import 2 replication targets are initialized with the following commands. USE [dbImport] -- Execute at the Publisher to ...
2
votes
2answers
64 views

Prevent SQL Server publisher from running out of disk space

I have an issue with transactional replication which leads to running out of disk space. The scenario is following. Database A is replicated to another computer via local distributor with command ...
1
vote
1answer
71 views

How to Properly shutdown and disassemble SQL Database Replication

While testing SQL Server Replication we setup Replication on our ERP Test DB from SQL Server Enterprise to SQL Server Standard. We have since got replication up-and-running on our Live database and ...
0
votes
0answers
86 views

Remove column from transactional replication

I have a situation where in I need to remove 1 column from transactional replication without actually dropping the column from table. Is it possible to remove it? When I try to do it from GUI it ...
0
votes
0answers
83 views

Transactional Replication issue due to big Transaction Log in sql server 2008 r2

I want an answer of question and that would be highly appreciated Scenario: First of all i am an IT guy from Sports Field and using SQL Server 2008R2. I have 2 production servers server 1 and Server ...
1
vote
1answer
51 views

Temporarily removing replication from Publisher

Is it possible to temporarily remove Transactional Replication from a publisher database in order to allow a release to be executed against the database? If I stopped the log reader agent would I be ...
3
votes
0answers
90 views

transaction replication causing too many deadlocks after adding a indexed view - what to monitor in order to avoid this?

I have created the following indexed view and its clustered index: This view was created on a subscriber database and all the tables used in the view are constantly being written to through the ...
1
vote
1answer
66 views

how to find the name of the distributor server and publisher server from the subscriber server/subscriber database

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column That I am already doing, and also adding ...
1
vote
0answers
40 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
5
votes
1answer
882 views

SQL Server Troubleshooting Replication and Long-Running fn_dblog query

I am trying to get (pull) Transactional Replication working again for a subscriber. Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
1
vote
1answer
555 views

Distributor latency - slow sp_MSget_repl_commands performance

One of our publishers is subscribed to by three subscribers, each subscriber is hosted on its own physical server. Two of those subscribers are 2008R2 and the third 2012. The 2012 subscriber is ...
4
votes
1answer
49 views

Transactional Replication to a Version Two Versions Older--Count by Name or Number?

According to Microsoft SQL Server documentation, a "Subscriber to a transactional publication can be any version within two versions of the Publisher version." In this context, are versions named ...
4
votes
1answer
180 views

Two-way replication between SQL Server 2008 R2 and SQL Server 2008 R2 SP3

I know that in SQL Server you can't have two-way replication between different versions. I wanted to know if SQL Server 2008 R2 and SQL Server 2008 R2 SP3 are considered "different versions"? Did ...
5
votes
0answers
92 views

Low performance, high availability, replicated key/value store with audit trail

I'm looking for a database system with fairly specific specs. I've looked most of the major relational databases and NoSQL products out there and did not find one that even remotely satisfied my ...
3
votes
3answers
6k 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. ...
6
votes
1answer
2k 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 ...
2
votes
0answers
113 views

Replication of specific tables using Postgres 9.4.4 and Amazon Web Services

I have currently setup a Postgres 9.4.4 RDS instance on Amazon Web Services. On this instance I hold 20 tables. In addition I also have Postgres 9.4.4 installed on my local server (OS: 64-bit Linux) ...
1
vote
0answers
41 views

Transactional replication taking hours to replicate

I have a bunch of tables replicated from my_publisher to my_subscriber via my_distributor. Some of these tables, not all of them, when updated on my_publisher, take a couple of hours to be updated on ...
1
vote
2answers
113 views

How to make distributor highly available in Always On Configuration

We have clients requested us to configure Always on with Replication. Microsoft does not support it. "The distributor should not be a host for any of the current (or intended) replicas of the ...
3
votes
0answers
133 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 ...
1
vote
1answer
4k 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
0answers
496 views

Transactional Replication Snapshots causing serious locking after 2012 upgrade

I am experiencing serious locking when adding new articles to an existing transactional replication publication, which is hanging the website. This is the first time I have attempted this since I ...
3
votes
0answers
235 views

SQL Server replication - error when creating a subscription - The article '(null)' does not exist

When trying to add a subscription to an existing publication use [Product] exec sp_addsubscription @publication = N'Product', @subscriber = N'REPLON1', @destination_db = ...
0
votes
1answer
618 views

sql server replication - how to find and drop subscriptions?

I had 2 subscriptions to a publication, but they were from the same subscriber server and writing to the same subscriber database, just one was bad and one was running fine. I could not find a ...
3
votes
1answer
2k 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 ...
1
vote
1answer
36 views

sql server replication - how to get combination of values from a binary(8) field?

I am using the table sysschemaarticles to collect information in my transactional replication. It is used for a variety of things including adding new articles and finding out who are the subscriber ...
2
votes
1answer
154 views

How to copy non clustered indexes in transactional replication

I create transactional replication ,but forget to include non clustered indexes and now my subscriber have only clustered indexes (primary key) and I want to transfer all nonclustered indexes to ...
0
votes
0answers
34 views

Should setting up SQL Server transactional replication require schema locks on published articles?

I'm attempting to setup transactional replication in a production environment. When adding columns to an article (calling sp_articlecolumn stored procedure), it appears to want to lock the published ...
2
votes
0answers
191 views

SQL Server 2008 Replication “between retries” or “worker thread no available”

All our existing servers are in SQL 2008 and I am in the process of upgrading to SQL 2014 and as well moving SAN to different SAN storage. As part of it I have to upgrade my distributor. We got ...
0
votes
0answers
91 views

Setting up mysql replication (Master->Slave one direction)

I am struggling with the setup of a one way replication for a single mysql table. What I have done so far: Master: Added this into my my.cnf: server-id=5668439 log-bin=mysql-bin ...
0
votes
1answer
69 views

SQL Server transactional replication issue with database

We have on the server a database and we want to replicate a database on another server. we've set a transactional replication, but we have issues with the default constraints on the tables: On the ...
1
vote
0answers
19 views

Transactional publication and database mirroring considerations

I've recently taken over a project, and with it comes 2 backends. 1st is the production services backend and the 2nd is a reporting service backend. Both of which are 2008r2 instances. The production ...
0
votes
1answer
79 views

BCP - Different Schema

I have a transactional Replication (Non-SQL Server Publishers - Oracle) implemented for one SQL Server Database. Let's say Publishers: A, B Subscriber: C Note: I can not modify the Oracle DBs. The ...
2
votes
1answer
891 views

SQL Server Cross Domain Transcational Replication

Has anyone got any documentation for doing/implementing Cross Domain SQL Server 2012/2008R2/2008 transactional replication document or steps (with screenshot or without screenshot)?
2
votes
0answers
24 views

Transactional Replication breaks when schema is changed in Publisher

We have set up Transactional replication where in two Publishers feed into one Subscriber , now if try to change the schema of any one Publishers or both publishers, replication breaks. We have ...
1
vote
0answers
33 views

How to mark loser as winner in p2p replication conflict resolution

We have sql server 2008 databases in 2 different regions that are p2p replicated. Now we can see there are some unresolved conflicts - most of them update/delete conflicts. The way our system is ...
4
votes
1answer
207 views

Moving Transaction Data To Another Database For Reporting Purpose

We got a requirement from our developer group, to do the followings: Frequently (every 30mins) move the transaction data out of live database to another database Secondary database will be utilize ...
0
votes
2answers
130 views

sql server transactional - replication - the internal procedures often deadlock with user processes

Very often I have deadlocks on my subscription server, involving the replication internal stored procedures and user processes either ad hoc or procedure queries. For example: Deadlock of the ...
1
vote
1answer
478 views

Peer-to-Peer Transactional Replication Load Balancing in MS SQL Server

I'm looking at Peer-to-Peer Transactional Replication and it looks like a perfect fit for my requirements, but there's one unclear part - load balancing (see picture below). How it is implemented in ...
1
vote
1answer
820 views

Transactional replication between SQL Server 2014 (Publisher) and SQL Server 2012 (subscriber)

We need to set up transactional replication between two servers A and B, configs listed below: Server A (Publisher) Microsoft SQL Server 2014 - 12.0.2254.0 (X64) Enterprise Edition (64-bit) ...
2
votes
0answers
308 views

Transactional Replication in SQL server 2014

We need to set up transactional replication in SQL server 2014, Enterprise edition so that: Database to be replicated from Publisher which is approximately 2 TB in size. This would be used 24*6. Here ...
0
votes
0answers
27 views

Transactional replication of stored proc execution and stored proc parameters

I'm trying to design how we might go about setting up replication of just the execution of a stored procedure. If the stored procedure on the source takes one or more parameters, will those same ...
1
vote
2answers
64 views

Can SQL Server Transactional Replication do this?

We have a production server and a reporting server, with transactional replication in place to move all inserts/updates/deletes from production to reporting. We're using SQL Server 2008 R2. We have ...
1
vote
0answers
436 views

Replication slowness: massive MSrepl_commands table?

Background: I have a SQL Server 2005 transactional replication setup that pushes normal traffic fine, but occasional larger processing batches have been a problem. Obviously the changes take longer ...