I'm a developer but I need to implement replication on an existing database. I'm a bit familiar with replication and I already was able to implement it but I had a few issues and the two most notable ones are:
Replication job affects maintenance plan -- it seems like the maintenance plan jobs can't be run because another job is currently running. I know some replication jobs are ran periodically. Can I avoid certain time of the day so it won't interfere with the maintenance plan?
The Distribution database grew too large and caused a no free space issue. Since this is transactional replication, publisher is continuously sending copies of the commands to the subscriber. How can I minimize the size of distribution database?
Replication has been stopped and the disk space issue is now fixed but this might happen again in the future. Before I attempt to set it up again, what should I take note of to set up the replication successfully next time?