This is concerning index rebuild's impact on transaction replication.
During an index rebuilds with full recovery mode, transaction log entries will be created (normal).
If I switch to bulk logged recovery, will:
- less data be replicated ?
- less mining of the transaction log occur ?
What I'm seeing after an index maintenance where some large table indexes are rebuild, replication will report "Approximately 5000000 records have been scanned in pass #4, 0 of which were marked for replication".
This concerns me in that "real" data changes are being slowed down in getting to the subscriber.