Questions tagged [transactional-replication]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
24 views

snapshot to apply just the schema changes - not the data

I am restoring databases to each side of my transactional and merge replications. Basically the publication and the subscriber are the same database initially. I still need to run the snapshot agent ...
Marcello Miorelli's user avatar
0 votes
0 answers
21 views

Changing a server name for SQL Server replication

We have two servers set up for transactional replication and we need to migrate all of the content from one of the sides (the distributor) to another SQL Server instance. Is there a way to change to ...
Richard B. Sorensen's user avatar
0 votes
0 answers
40 views

Replication Reinitialization from backup

I have Reinitialization transactional replication of 950 GB database from backup. It is working fine. I left allow_anonymous & immediate_sync 1 i.e true. I plan to keep it as true. Is that fine or ...
Saran's user avatar
  • 71
0 votes
2 answers
23 views

Should I stop replication logreader and distribution jobs during database maintenance (reindexing, updating stats, and checkdb)?

I have transactional replication setup in SQL Server 2022. I have a distribution server running push subscriptions to subscribers. I'm trying to figure out if I need to stop replication jobs (log ...
dba_gal's user avatar
0 votes
1 answer
24 views

Initialize transactional Subscriber SQL server

As a requirement to get new data from publisher to subscriber. I used generate new snapshot and run log reader and run distribution agent. Would like to know which option is we use to initialize ...
Saran's user avatar
  • 71
0 votes
0 answers
16 views

Initialized Replication Subscriber from Backup with @allow_anonymous,@immediate_sync off

I have initialized Replication Subscriber from Backup with @allow_anonymous,@immediate_sync = flase It is working good. Do I need t o change the setting back to true or just leave with false.
Saran's user avatar
  • 71
0 votes
0 answers
36 views

SQL Transactional Replication Limits

I am seeing strange behavior in a Transactional Replication configuration. Details: Publication Server SQL 2017 Standard Distribution Server SQL 2017 Standard Subscriber Server SQL 2017 Standard 55 ...
Garry Bargsley's user avatar
0 votes
0 answers
27 views

What is the easiest way to do filtered replication to another SQL Server 2012 database with the exact same schema?

I need to start a filtered replication of a SQL Server 2012 database for a company subsidiary that contains only a subset of records related to that subsidiary (using only row filters). This is in ...
GratefulDisciple's user avatar
0 votes
1 answer
31 views

SQL Server replication: Need to remove articles from the publication

I am replicating the data from the Database1 on Server1 to respectively, Database2 on Server2. Now, the requirement is to remove certain tables form being replicated - so I will remove them from the ...
Dmitriy Ryabin's user avatar
1 vote
0 answers
44 views

PostgreSQL replication role without permission to see or delete other replication slots

We have a PostgreSQL server with multiple databases for different projects. We want to use logical replication on those databases so the applications receive all the changes for their replication slot ...
Eleasar's user avatar
  • 111
0 votes
1 answer
23 views

heavy read load on subscriber db can hit the performance of sql server transaction replication from publisher to subscriber?

Can heavy read load on subscriber/replica db (used for analytics purpose) can hit the performance of sql server transaction replication from publisher to subscriber/replica? We have noticed that when ...
Praveen Suhalka's user avatar
0 votes
1 answer
94 views

Transactional Replication - Issue in Availablity Group

We have 3 Node SQL Server Cluster (Always On availability group). I wanted to implement Transactional Replication on 3rd Node which is configured as Asynchronous. When I tried to create Publisher, ...
Shivkumar Mallesappa's user avatar
0 votes
0 answers
19 views

Can you run SQL distribution agent as service account and connect to distributor with windows account or does it have to be a SQL account?

Setup: 2 SQL Server 2022 instances, PubServer and SubServer. Configured PubServer as publisher, SubServer as subscriber. PubServer has transactional publication created and working. Share and file ...
user avatar
0 votes
1 answer
23 views

Transactional Replication - Insert after Delete not working

We wanted to have a DR setup for our SQL Server databases. So for testing purpose we went ahead with Transactional Replication. Setup Server 1 (SQL Server 2019): Acting as Distributor and Publisher ...
Shivkumar Mallesappa's user avatar
0 votes
0 answers
37 views

How to find the records that are waiting to be replicated?

I had a look using the replication monitor and it is showing me commands that are awaiting to be replicated: My question is - how do I find out what these commands are? I Have tried this query by Ben ...
Marcello Miorelli's user avatar
0 votes
1 answer
38 views

what is stopping my transactional replication services?

I will be straightforward and put my question before I add any other information, as I want to keep it objective and to the point. the question is: How to find out why the replication services are ...
Marcello Miorelli's user avatar
0 votes
0 answers
15 views

SQL transactional replication find force_invalidate_snapshot is 1 or zero for all article

Is there any way to find SQL transactional replication @force_invalidate_snapshot is 1 or zero for all article? Just wanted to know or find number of tables before I run EXEC sp_refreshsubscriptions ...
Saran's user avatar
  • 71
0 votes
0 answers
23 views

SQL Replication Article added date finding

is there any code available to find SQL Replication Article last added date. If any new article added I would like to generate an alert.
Saran's user avatar
  • 71
0 votes
1 answer
292 views

Initial snapshot not yet available adding subscription issue

I am experiencing some issue with my subscription (transactional replication) recently as whenever I tried to add a new subscription to my existing publication either way I use Initialize when ...
Caspersky12's user avatar
0 votes
1 answer
35 views

Numerous "truncate table dbo.MSreplication_monitordata" commands logged by distribution database

In doing a SQL Server audit, it was discovered that after hours last week, the distribution database started logging numerous "truncate table dbo.MSreplication_monitordata" commands. I can't ...
user avatar
0 votes
1 answer
105 views

sql server replication issue

My SQL Server version is 2012 R2. I have one publishing machine with several publications, one distribution machine, and several subscription machines. Everything is working fine. However, when I try ...
Mr.spark's user avatar
-3 votes
1 answer
59 views

Please I received this error on a scrub process “scrub failed, no running scrub jobs”

Please help it is urgent . The database is also in replication enter code here
aee's user avatar
  • 11
0 votes
1 answer
116 views

MS SQL Server Replication - stored procedures sp_refreshsubscriptions and sp_addsubscription blocks all tables of a publication with SCH-M lock

The setup: A push transaction replication is configured for about 20 tables/articles at SQL2019 CU31 Standard. Some of the tables are permanently under a load of thousends of inserts per second. In ...
Evgeny Veselov's user avatar
0 votes
0 answers
37 views

Suppresion de réplication sql-server impossible, sp_removedbreplication crashes

Following the restoration of a replicated database onto another replicated database, the sp_removedbreplication fails. Msg 208, Level 16, State 1, Procedure sp_MScheck_dropobject, Line 9 [Batch ...
Sylvain COURTECUISSE's user avatar
0 votes
0 answers
80 views

Replication-Replication Distribution Subsystem: agent initialization failed. The publication (publication name)does not exist. Error: 14173,sevirity18

In SQL logs, we are getting above replication warning messages continuously for every around 30 seconds for few publications but from these one deleted earlier but other three publications are still ...
Ankamma Rao Battula's user avatar
2 votes
0 answers
81 views

Transactional replication not replicating with 'The process is running and is waiting for a response from the server' error after adding new article

I have a Transactional Replication setup which has been working fine for a long time. It is a Pull Subscription. I got a new requirement to replicate a large article which is 10GB. allow_anonymous &...
Sowjanya Ravi's user avatar
1 vote
1 answer
49 views

Is it possible to replicate a SQL database to a database with a different structure?

There is a mariaDB instance that is already running and has data in many tables. Let me call this old database. Say, the structure (tables and their fields) were not well thought out and hence lead to ...
hwhap's user avatar
  • 13
0 votes
0 answers
98 views

Disabling Replication and Replicated Tables

I have transactional replication set up between Database1 and Database2 using SQL Server 2017. About 20 tables are being replicated to Database2, a few of them are pretty large. I would like to ...
user2608654's user avatar
0 votes
1 answer
26 views

SQL Server database migration to Azure SQL Database

We are currently in the process of setting this up, but my boss has asked whether a restore of any of the 13 databases will affect the local publications/ Subscriptions which have been set on the ...
delmc18's user avatar
  • 11
0 votes
0 answers
51 views

SQL Server Replication between two AlwaysOn HADR Clusters

We got a requirement to replicate data between two different HA Clusters. ---Current Prod Environment------- SQL Server 2016 Servers HADR Cluster 1 (HA1) - Primary Replica (PR1), Secondary Replica (...
Kris's user avatar
  • 422
-2 votes
1 answer
37 views

Is there support for distributor server failover?

I have done googling for this question. The answer is no. But the answer is on year 2015. How about now? Is the distributor server have failover support capibility?
zul nasir's user avatar
0 votes
0 answers
312 views

Is uniqueidentifier column in table in MS SQL can be used in Transactional replication?

This is a ReportServer from SRSS, it has custom default value that we can't change, and some of our teams need it to be replicated to other server. I really curious, because I can't find this in any ...
Benyamin Limanto's user avatar
0 votes
0 answers
116 views

Stored Procedure Validated Using EXEC sp_refreshsqlmodule but Fails to Execute at Subscribers

Testing a transactional replication pub/sub with over 2.5K articles against a database that has been around for over 20 years and was recently updated to SQLSERVER 2019. There are some modules that do ...
Ross Bush's user avatar
  • 505
0 votes
0 answers
68 views

SQL Server 2017 Replication using FTP raise error Agent message code 20033. The process could not retrieve file from FTP server

I'm try to use ftp in SQL Replication. My Publisher server is on Windows 10 Pro, with FTP enabled for the ftp folder in repldata. The subscriber is on Linux using container, both are SQL Server 2017 (...
Benyamin Limanto's user avatar
0 votes
1 answer
28 views

How to setup transactional replication on dedicated server using AG database with auto failover

My plan is i have One dedicated server for Transactional replication as subscriber. And two nodes in Availability Group. I want to replicate one availability database on primary as publisher. When ...
zul nasir's user avatar
1 vote
0 answers
1k views

Publication Error: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction

I got some requirement to implement transactional replication, so I am doing some research on it, but I am getting some issues while creating the publication. I have restored adventure works database ...
Ankit Gupta's user avatar
0 votes
0 answers
72 views

Configure SQL Server merge replication in local machine and a server machines

I have two databases on my local machine and the server. I want to sync them whenever they are being changed. For my scenario I'm using SQL Server replication. I use merge type to sync these databases ...
mohammad kamali's user avatar
0 votes
0 answers
250 views

MSSQL replication snapshot agent fails

I'm using MS SQL server 2019 on Linux. I'm trying to create a transactional replication. The problem is that when I create a publication, the snapshot agent can not start. Basically, I'm getting this ...
iRakic's user avatar
  • 1
1 vote
1 answer
111 views

Advanced SQL Server replication scenario

I have a MS SQL Server based application with non-trivial schema (has indexing, clustering, transactions, views, stored procs, ...). The application itself has some features that need up-to-date data ...
Simo Erkinheimo's user avatar
0 votes
1 answer
267 views

SQL Managed Instance Replication (Snapshot Agent) Timeouts

I have setup Transactional Replication on one of our Azure SQL Managed Instances, and I'm running into an issue with the Snapshot Agent. It starts without any problems, gets to 84%, stalls and then ...
Tom's user avatar
  • 191
2 votes
1 answer
628 views

Merging data from identical tables from multiple databases into one larger table. N-1 table replication

There are N databases with identical table structures in a multitenant, multi-database system. The desire is to replicate a table(s) from these databases into a single larger table in a OLAP database, ...
Ross Bush's user avatar
  • 505
0 votes
1 answer
172 views

Can we keep change-tracking on a replicated table going after changing the distribution database?

We have an MSSQL replicated table which has change-tracking set up on the subscribed table. The change tracking is used to send changes into Snowflake. However - now we need to reconfigure replication ...
Rawheiser's user avatar
  • 133
0 votes
0 answers
281 views

Transactional Replication Errors - Missing and Duplicate Data at Subscriber

We recently experienced errors with SQL Server Transactional Replication on a client's system. Replication is running from a SQL 2017 server to an Azure DB. Initially some replicated update commands ...
Lectric's user avatar
0 votes
1 answer
650 views

message 'The Distributor has not been installed correctly'

I get the message The Distributor has not been installed correctly Could not enable database for publishing when trying to execute sp_replicationdboption. The publisher (which is on separate server ...
Christine Glew's user avatar
0 votes
2 answers
266 views

SQL - Transactional Replication between existing databases

I want to reconfigure a Dynamics AX 2012 SQL Server to improve performance of an existing architecture where one SQL server is used for both transactions and reports. This reduces SQL performance ...
Mandeep Singh's user avatar
-1 votes
1 answer
202 views

Peer to Peer Replication in MS SQL Server [closed]

Is it good practice to use Peer to Peer Replication in MS SQL 2022 (Enterprise Edition) within Windows 2019 Server (three servers)? I want to create three replicas of my client's database and to use ...
Kazi Shahid's user avatar
0 votes
1 answer
1k views

logical replication initial phase

I am about doing replication for 16 millions record. Just want to ask about the initial phase of logical replication : Do I need to copy the initial table from publisher to subscriber first ? Or is ...
padjee's user avatar
  • 187
0 votes
1 answer
577 views

SQL server replication conflicts

Once per week, a snapshot publication is done from a database "myDB" in PROD to "myDB" in PREPROD. Now in PREPROD we set up a transactional replication between "myDB" to ...
jpprade's user avatar
  • 145
2 votes
1 answer
116 views

Load of Transactional Replication at the Publisher

I would like to enable replication on my SQL Server , as per the Document , the load on Server as a Remote Distributor is less(i.e. 8-10% for insert/update in publisher) when compared with load on ...
IT Researcher143's user avatar
1 vote
1 answer
47 views

Drop Subscriber at SQL Transactional replication

We have SQL Transactional pull replication: Publisher and Distributor are at the same server - ServerA. It publicates Publication1. Pull Subscribers to Publication1 are - ServerB, ServerC and ...
NewUser's user avatar
  • 11

1
2 3 4 5
11