Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [transactional-replication]

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

0
votes
1answer
25 views

Can an AlwaysOn Availability Group be used to mitigate downtime when there's replication syncing issues on the primary server?

Once in a while I'll run into syncing issues with my subscriber server in a transactional replication setup. Taking a new snapshot of the publisher causes significant downtime on my subscriber server. ...
0
votes
0answers
24 views

The right choice to distribute reads and writes on different servers [on hold]

I have to get applications on my SQL Server 2017 Standard make reads faster and writes faster. Sometimes the reads and even the updates got blocked (300 deadlocks from the start of year). I have the ...
0
votes
2answers
37 views

Can Transactional Replication and triggers be used for near-realtime ETL [closed]

We want to have a data warehouse synced with our production OLTP database in near realtime. Is it possible to do this with Transactional Replication and triggers? How we currently ETL We use sql ...
0
votes
0answers
14 views

Failover cluster server that is subscriber in trans. replication, possible to failover apps to server B in cluster while server A is re-syncing?

(Sorry for shotty title, max characters FTL.) Once in a while, I'll run into issues with my transactional replication when my publisher's schema changes. For example, sometimes we'll add new fields ...
0
votes
1answer
23 views

SQL Server Transactional Replication from 2005 to 2017

As per the msdn, Subscriber version depends on the type of publication: A Subscriber to a transactional publication can be any version within two versions (n-2) of the Publisher version. For example: ...
0
votes
1answer
25 views

Replication SQL Server 2016

Good afternoon, I am trying to perform a transactional replication in sql server 2016, and I have the following problem. The scenario is as follows: A publisher server and a subscriber server, the ...
1
vote
1answer
36 views

Set up new publication on SQL Server 2014 database which is part of an availability group

I like to setup a publication (transactional replication) on a SQL Server 2014 database which is part of an availability group. We have a primary and one secondary (non-readable) replica. On the ...
2
votes
1answer
41 views

SQL Server 2014 AOAG + Replication?

I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers ...
0
votes
1answer
48 views

How to check when a record is replicated in SQL Server

I have configured a database installed On-Premise to replicate certain tables on a Cloud SQL Server database hosted on Azure. The replication task is scheduled to run at specific time everyday and I ...
0
votes
0answers
15 views

SQL Server replication model snapshot, transactional and merge - which method can be used

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is ...
0
votes
1answer
23 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
0
votes
2answers
21 views

How to pause the subscriber end of transactional replication

How do I go about pausing transactional replication on the subscriber end. We have a publisher on Server A, a distributor on Server B and a subscriber on Server C. All are in the same network. Some ...
0
votes
1answer
38 views

Upgrade SQL Server 2008 R2 to SQL Server 2012 and then set up data replication to SQL Server 2016

Currently I have a Windows 2008 server with SQL Server 2008 R2 and I want set up a data replication to a Windows 2016 Server with SQL Server 2016. I am aware that the aforementioned is not possible ...
0
votes
0answers
27 views

SQL Server Replication Error - The process could not connect to Subscriber

I have setup transactional replication by following link. Everything I did as per document. But when I verify synchronization status, as per mentioned link, I receive an error The process could ...
0
votes
1answer
28 views

How to handle set up real time DML and DDL statements sync between two DB servers SQL Servers

We are looking to offload the data from a Production enviroment to a reporting environment. I currently have an SSIS package setup to extract and load data between the two servers. However, now ...
0
votes
1answer
30 views

Replication stalling on one subscriber

I currently have transactional replication set up for three databases from the same Publisher to the same three Subscribers in SQL Server 2005. Publisher and Distributor are on the same server. One ...
0
votes
1answer
55 views

is this time to remove the databases from the availability group? which ones?

While patching one of my servers that is part of an availability group, as a secondary, I had some problems - the real problem was that the host machine of one of the virtual servers in the ...
1
vote
0answers
62 views

What are the requirements for SQL Replication on Azure SQL DB Managed Instance?

We are seeing if it is feasible to setup Azure SQL DB Managed Instance (SQL MI) and an Azure VM with SSMS installed for this replication scenario: We have a vendor who needs access to our SQL Server ...
1
vote
0answers
43 views

Resynchronize transactional replication in SQL Server 2012 without doing a complete reinitialization after disk filled

We have a DB that is doing a transactional replication to one other server. There are three tables it is replicating in the DB. Yesterday the subscriber ran out of disk space. This caused the ...
1
vote
0answers
22 views

Heterogenous Database Replication

How can we establish a real time synchronization from SQL server to PostgreSQL Database? We have tried to automate the jobs in BI but that does not serve the purpose as we need real time data from ...
1
vote
1answer
34 views

How to mark a table as pre-populated with postgresql logical replication

I accidentally loaded data into a table before setting up a logical replication subscription for it and now I'm getting errors when I try to sync it (duplicate key already exists). I can't delete ...
1
vote
0answers
59 views

Configure Always On for publisher

We have a pull transaction replication.Publisher runs MSSQL 2016. Distributer runs on separate server with MSSQL 2016. Is it possible to define Always On over publisher and another new server, so ...
1
vote
1answer
26 views

Enable Replication/CDC from High Availability Group

I am a newbie to this Replication concept and I am trying to build some scripts to automate our Build Process where we will be disabling/re-enabling Replication on a regular basis. Background: We ...
2
votes
2answers
170 views

Sql Server : How to query list of subscriptions and Articles (for a given publication) from Publisher

In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) Yes, there are easier ways to query from Distributor ...
1
vote
0answers
34 views

Transactional Replication from Copy Only Backup

Is it possible to use a copy only backup when initializing a subscriber from a backup? I've been trying it but getting all kinds of issues with: Trying to update records that don't exist Inserting ...
1
vote
1answer
137 views

how azure sql geo replication works internally?

My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup ...
2
votes
1answer
257 views

Efficiently bulk upsert unrelated rows

As part of a manual replication process between databases with different but related schemas, for each table, we identify new and modified records in the source database and feed them via a table ...
6
votes
1answer
134 views

Database Compatibility Requirement for Transactional Replication

Does the subscriber "within two version requirement" for transactional replication from this MSDN article apply to the SQL Server Instance, Database Compatibility Level, or Both? For example, would ...
2
votes
0answers
36 views

Foreign Key Error with Transactional Replication from Backup

I'm getting a missing foreign key error when I begin transactional replication. Steps taken: Created a pull publication (live server) Created a copy only full backup Restored backup on reporting ...
0
votes
0answers
179 views

Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) two times

Whenever I have to drop a publication I follow the steps below, ending by a call to sp_droppublication when I get the error below two times. The publications seems to have been dropped successfully ...
1
vote
1answer
25 views

I want to Create a brand new slave for my MySql Percona server 5.7

I have a Master Master Replication setup using mysql Percona Server 5.7, but for some unknown reasons, seems like my passive server is broken "thats not the issue", the replication is bad and the data ...
0
votes
2answers
30 views

Transactional replication failure handling

Web Application is High school record management system (HSRMS). Users of the application are High school management (Normal Users) Data verifying users (Admin) User group 2 will allow the User ...
4
votes
1answer
341 views

Can I use only 1 user for SQL Server replication?

I want to setup transactional replication on sql server. By following the instructions of the ms replication preparation tutorial and the ms replication configuration tutorial, everything works fine. ...
1
vote
1answer
63 views

Transactional Replication Synchronization taking too long to respond

I successfully generated the snapshot, but subscription is not working correctly. Either the synchronization takes too long to respond or it simply displays the text shown in below attached screenshot....
1
vote
1answer
76 views

Cleaning up MSrepl_errors, SQL Server Replication

Our MSrepl_errors table is around 15GB and got records from the beginning of time. What is the correct way of cleaning up this table. Do we simply delete from it? Edit The distribution agent clean ...
0
votes
1answer
30 views

what is a safe way to stop the logreader?

Applying cumulative updates and service packs on sql server 2016 - The server is involved in transactional replication, being a publisher, The server is also a virtual machine. I need to stop the ...
1
vote
1answer
57 views

is there a way to improve this query by not re calculating functions? cross apply?

when I set up replication I like to take a count of each table in the publisher, then I go to the subscriber I do the same thing in order to compare both pictures. this is the picture from the ...
1
vote
1answer
23 views

Publication shows up in secondary server

I have created log shipping and the primary server is also used for transactional replication. Now after creating log shipping I have noticed the publisher shows up on the secondary and it wont let ...
1
vote
1answer
86 views

Issues setting up a publisher for transactional replication on a SQL Server with a custom instance

I'm trying to set up transactional replication of a fairly large database (Business Activity Monitor database from BizTalk Server 2013R2) (>500 GB). I have an active/passive cluster which holds the ...
0
votes
0answers
46 views

Schema changes in transactional replication

I have a publisher (SQL Server cluster) in one box and the distributor/subscriber together is on the other box. I have a requirement by the vendor that if there is a new build (schema/database ...
3
votes
1answer
129 views

How to completely get rid of replication subscriptions?

I have restored a database in another server. I don't want any of the transactional subscriptions of the former database. I already called exec sp_removedbreplication 'MyRestoredDB' go And also ...
2
votes
1answer
24 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...
0
votes
1answer
28 views

Mail Alert when threshold of 10000 pendingcmds are breached

I currently have the below running to monitor replication and send a mail when the threshold of 10000 pendingcmds are breached, however the alert mail is generated every 5 minutes regardless of the ...
0
votes
1answer
40 views

Saving all sql server transactions to txt for a transactional replication to another database [closed]

I have sql server 2014 running my main database at location A. I want to know if it would be possible to export all insert,update and delete queries to txt files for me to then run on a off site ...
2
votes
3answers
150 views

SQL Server replicating data to an archive

I have the following scenario: Multiple SQL Servers where production machines log about 80GB of data (mostly images) daily in a database (each machine has a server with one database). Since these ...
0
votes
1answer
140 views

How to set up a transactional replication to an Always On Availability Group (AG) with two replicas through connecting to the AG Listener

I want to replicate some tables on a SQL Server instance (Publisher) to an Always On Availability Group (AG) with two replicas (nodes) using its Availability Group Listener. The Distributor is the ...
2
votes
0answers
257 views

SQL Server: Replicated transactions are waiting for the next Log back up or for mirroring partner to catch up

I have two SQL Server DB instances on the same machine with one hosting a replica of the other. In addition, I have transaction replication setup for all tables on the main instance to the replica. I ...
0
votes
1answer
64 views

What would cause a transactional replication subscription to restart repeatedly with no errors?

I have set up a transactional replication publication/subscription to test a migration from an on-premise SQL 2016 Enterprise Edition installation to Azure SQL DB and I'm finding that when the ...
2
votes
1answer
136 views

Replication from Amazon's RDS to Postgres via DMS errors out

I have a transactional replication from SQL Server 2008 to RDS SQL Server 2016 in 2014 compatibility mode. This works okay. I now want to replicate this RDS database via DMS to Postgresql. This errors ...
1
vote
1answer
53 views

Database Replication SQL Server

We have to do database replication with SQL Server; the two database are on different servers. We achieve replication, but our scenario is when live is down so we use replicated server as our ...