All Questions
Tagged with transactional-replication sql-server-2017
4 questions
1
vote
1
answer
269
views
Is it safe to turn on Delayed Durability on a transaction replication subscriber?
In a transaction replication environment with a publisher SQL Server that receives frequent inserts and updates from an application and a subscriber SQL Server with pull replication jobs, is it safe ...
- 13
0
votes
0
answers
100
views
Snapshot backup size increase after starting transactional replication
The size of the snapshot backups went from 1.6 GB to 16 GB one week later after starting transactional replication. Does anyone know why this might be happening? I'm using SQL Server 2017.
- 41
3
votes
0
answers
2k
views
MS SQL Server 2017 - Error following official tutorial - creating new publication while setting up transactional replication
I am trying to set up replication using SQL Server 2017 Developer edition. The publisher, distributor, and subscriber are all local. I have been (faithfully) following the tutorial here:
https://...
- 3,165
0
votes
1
answer
1k
views
Replication setup from higher version to lower version In SQL Server
Is it possible to create Transactional Replication setup between 2017 Enterprise edition to 2005 Standard edition in MS SQL Server?
I heard that it is possible through scripts, is it right?
- 11