Stack Exchange Network

Stack Exchange network consists of 174 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
0answers
16 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
23 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
28 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
43 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
32 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
32 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
20 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
15 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
58 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
24 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 ...
1
vote
1answer
48 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
28 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
votes
0answers
76 views

Azure Managed Instance - Replication Setup Issue

We have been trying to setup transactional replication on an Azure Managed Instance database. I have been following the document from Microsoft: https://docs.microsoft.com/en-us/azure/sql-database/...
1
vote
1answer
62 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
77 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
80 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
28 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
83 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
21 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
25 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
337 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
35 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
45 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
29 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
63 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
32 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
63 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
22 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
27 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
103 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
62 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
198 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
59 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
104 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
52 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 ...
1
vote
2answers
58 views

Transaction Replication:Intialize from Backup

I have a database which i want to replicate to another server. Since the database is huge(~1.5 TB) i have decided to do initialize from backup. But since it is a production live database,new insert/...
0
votes
0answers
37 views

Transactional Replication without initialization: Subscriber not active

I set up a transactional replication on my SQL Server 2016 instance. Everything was going good until today. When I checked replication monitor, I noticed that replication had failed; that ...
0
votes
0answers
18 views

Transaction Replication from multiple servers is truncating the destination table

I am trying to centralise the results of sp_Blitz from multiple servers into one centralised server using table level transaction replication. At the moment I am just testing this to make sure it ...
0
votes
0answers
156 views

MongoDB - Azure Cosmos DB replication?

What would be the easiest way to replicate an on premises MongoDB to an Azure Cosmos DB? The ideal scenario for me should be a transactional replication.
1
vote
1answer
88 views

Transactional Replication initialize from Backup Issues

I implemented Transaction Replication (pull subscription with distributor at subscriber) with initialize from backup. It was working good and today when i checked replication monitor,it shows error on ...
0
votes
1answer
49 views

MS SQL Server: Replication Monitor Transactional Replication Publisher Log Reader Agent Latency Too High?

Is my Transactional Replication's Publisher's Log Reader Agent Latency too high?
1
vote
1answer
63 views

MS SQL Server: Transactional replication not working but no errors are present

(MS SQL Server 2008 R2) I have transactional replication setup from server A to server B. Server A is an Oracle server, so the publisher and subscriber both reside on server B (SQL 2008 R2). It was ...
0
votes
0answers
40 views

Does PostgreSQL Logical Replication replicates data or query?

Context To implement a custom inheritance model in my database using PostgreSQL 10.4 and to avoid coupling the base type to the specialized types, I created a small table concepttype_regclass for ...
2
votes
2answers
75 views

Using transactional replication to roll back from SQL server 2014 to 2008R2

I know it sounds crazy. However its just a thought given by DBA,s and management to check on. We are going to use LS to do migration of around 10 TB Db from 2008R2 to SQl 2014. This DB is 24*7 in ...
3
votes
2answers
282 views

Transactional Replication Reinitialize

I'm using SQL Server transactional replication and looking for ideas on reducing the amount of downtime caused by re-initializing subscriptions. I have multiple publishers pushing data to a single ...
0
votes
0answers
15 views

How to Setup a Distributor for Replication on Different Server in 2014

I have 2 replications running on the server both of them are using the same source db. How ever I would like to select a different distributor for one of the publication and the other one using the ...
0
votes
1answer
178 views

Transactional Replication: Maintaining schema changes

Whats the best approach to not to break replication but still apply schema changes to Primary and Secondary ? (not just DDL, new articles etc) We have a huge database, so we had to go with ...