SQL Server Performance

recovery model and replication

Discussion in 'Performance Tuning for SQL Server Replication' started by amara, May 15, 2008.

  1. amara Member

    Hi, We have a setup with transactional replication..The databases are in full recovery mode..
    Can we have DB's in simple recovery mode in replication????????????????
    Also pls let me know the kinds of recovery models that suit for all kinds of replications
    amara, May 15, 2008
    #2

  2. MohammedU New Member

    You can have SIMPLE recovery model for replication but incase of server failure your can't recover upto the point...if you are not worried about database recovery issue incase of disaster then SIMPLE should be fine.
    MohammedU, May 15, 2008
    #3

  3. amara Member

    Will all kinds of replication( transactional, with updatable and merge) work with simple recovery model. Please sugest soon as we have to implement this on a customer server
    amara, May 15, 2008
    #4

  4. satya Moderator

    You need the FULL mofrl if you are using replication and need the ability to resynchronize all databases involved in replication to a specific point in time.
    satya, May 19, 2008
    #5

Share This Page