Backing up And Restore rplicated DBs

  • I need Recomndation OF Backing Up and Restoring of Replicated Database both Publisher And SubScriber

    What Happans after the restore

    Who do I maintain syncroniztation and data integrity ?

  • Wich type of replication do you have? your Backup strategy will change depending the type of replication.

    For transactional check for the option 'sync with backup' in BOL. This will keep the syncronization between your published database and the distribution db.

  • I Will Have Some SnapShot Replication

    (Each SnapShot Replication Group Severl Articales, and Applied at diffrent times and reintilized in diffrent times).

    I will also have Transactionl and merger Replication on other Articals In the Same DataBase.

    I might Astablish an On Demand Publication to Trnasfer A snapshot of One Article.

    (I am Not Sure It Is Posible at all)

    Can The Same Article Be at to difrent publication and to diffrent subscription that runs on the Same Subscriber?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply