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

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

1
vote
0answers
25 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
16 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
24 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
27 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 ...
0
votes
0answers
19 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
29 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
24 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
67 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
27 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
24 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
19 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
23 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
30 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
33 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
22 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
38 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
23 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
36 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
21 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
25 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
73 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
49 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
130 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
53 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
85 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
54 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
32 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
16 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
115 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
71 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
42 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
59 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
32 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
71 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
217 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
14 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
137 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 ...
0
votes
1answer
65 views

how to get ALL the objects in a database that are NOT FOR REPLICATION?

“Not for Replication” is a property which can be set for different objects like check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. What ...
0
votes
1answer
104 views

Transactional Replication hangs when huge transactions flow

We are running push transactional replication in our production environment ( SQL server 2014 (x64) Default configuration). It hangs when thousands of live transactions flows in and this continues for ...
3
votes
1answer
42 views

Initialize replication sql server from backup of many databases

I want to know how I can initialize a subscription from a backup of a publication database. I have three diferent databases that will point to the same subscriber. For the first time there is no ...
2
votes
2answers
178 views

Domain Account or Windows account for Transactional Replication

All the online resources say to use a Windows account for Agent accounts, i.e. Snapshot, Distributor and Log Reader to set up Replication. See the following links as examples: Tutorial: Prepare SQL ...
1
vote
0answers
18 views

Replicate multiple on-site SQL Server databases to Azure

I have a SQL Server Express 2014 named instance containing 3 databases (One for each office). connected to a WinForms application. Each database is uniquely named after the respective office although ...
0
votes
0answers
117 views

SQL Transactional Replication - some tables frozen, but others working fine

Background We are "republishing" 20 SQL Server 2012 source databases, using SQL 2016 as the republisher and subscribers, with SQL 2017 acting as the single distributor for both "hops" (Hop 1 being ...
0
votes
0answers
48 views

Can I create a replication table with extra column only on subscription side?

I am having a tricky situation regarding replications in MS SQL server. We are building a SQL Server Analysis Services Cube DB for our new reporting system. This requires to retrieve data from ...
1
vote
0answers
57 views

Can I run an index rebuild on a sql server HA replica or a copy the DB, and then swap with the primary?

We have a large database hosted in sql azure and we need to occasionally run maintenance tasks such as index rebuild. Pretty common of course, and we also try to minimize downtime. We use the premium ...