• We are considering setting up a Transactional Replication and have some questions you could possible help us with.

    When continuously, how often does the log reader agent update? Does it start as soon as the last Transaction is completed? If you don't set a scheduled time does that mean you are in the continuous mode?

    We plan to have the subscriber as read only, is there a way to guarantee this beyond setting role\user permissions restrictions?

    Eventually we want to break the replication and use the subscriber as the active database. What would be the best way to do this and have the most up to date information on the subscriber at time of separation?