Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [transactional-replication]

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

The automated distribution of transactional changes from a publishing database to one or more subscriber databases. The changes are published to the subscriber in near real time and in the same order as they occur at the publisher and within the same transaction

509 questions
0
votes
1 answer

How to recover from transaction replication failure?

My transaction replication works such that, to curb data growth, every day articles in publishers are purged but this purging of data is not replicated on to the subscriber. So at any point of time my publisher only has current day's data and my…
varun
  • 43
  • 4
0
votes
1 answer

Restore of Replicated Database fails with “Cannot drop the table because it is being used for replication.”
published database restoration failed once you setup transactional Replication using system Store procedures. Few work around to this problem is restore with KEEP_replication option and than drop the publication and subscription. Is there anything…
Piyush Patel
  • 71
  • 3
  • 12
0
votes
1 answer

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 transactional replication lags, and we stop heavy…
Praveen Suhalka
  • 1
0
votes
0 answers

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 available, running and replicating the data into…
Ankamma Rao Battula
  • 1
0
votes
1 answer

When I do transactional replication does SQL truncate T-Logs on the Publisher?

I would like to do Transactional replication 10 tables on a Prod server to a Secondary server. The prod server is in Full mode and has t-logs. Secondary is in Simple. Can I still capture T-Logs from Production and restore them (with a full…
IMeitzen
  • 35
  • 4