transactional replication doubt? RRS feed

  • Question

  • To initialize a subscription to a transactional publication from a backup, enable the publication to "allow initialization from a

    backup", and then specify backup information when creating the subscription.

    That means we are not using snapshot in this scenario.

    We need to keep backup file in disk after successfull configuration of the transactional replication, because if some thing

    happend to the transactional replication in the future, then snapshot agent can access initial snapshot from backupfile(i.e.
    reinitialization of the transactional replication).

    it is right or not?

    Thursday, May 5, 2011 12:43 PM