Home Forums SQL Server 2005 SS2K5 Replication Will Transactional Replication Supports Simple recovery Model ? RE: Will Transactional Replication Supports Simple recovery Model ?
Ian Scarlett
SSC-Insane
Points: 23197
More actions
March 28, 2011 at 1:19 am
#1304194
Yes, you can use the Simple recovery model... the transaction log is only truncated after a checkpoint AND all transaction marked for replication have been processed.