Hello, Two questions regarding replication, assuming a unidirectional replication is needed, running main database on machine A and backup database on machine B.
1. Performance wise, is it better to run the replication on machine A or B? (i.e. the source should be the remote machine or the local). 2. What is the toll on running the tasks on both machines? (still having unidirectional replication, only from A to B. I raise this option because the replication should be executed each time the machine starts, so the way to assure it without extra means is ti execute on both at startup). Thanks!
