replication with simple recovery model

• rajesha

  SSC-Addicted

  Points: 412

  More actions

  January 23, 2003 at 3:37 am

  #80187

  i have a database in sql2k with recovery model "simple".since the transaction log is getting truncated after each transaction committed,if i replicate this database on a periodic basic

  will the replication work successfully or is there any problem..?

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  January 23, 2003 at 11:44 am

  #447076

  I have many published dbs running Simple recovery and I haven't noticed any problems.

  KlK, MCSE

  
  KlK

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 23, 2003 at 12:22 pm

  #447080

  It will work fine - transactions wont get truncated from the log until the logreader agent has processed them.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter