changing the recovery model

• Aayush-176728

  Mr or Mrs. 500

  Points: 527

  More actions

  September 28, 2004 at 1:59 pm

  #83839

  Hi sql gurus,

  i have setup merge and bi directional transactional replication between 3  servers. and in the primary server on every week end that is saturday night 11:30 i do run the dbcc dbreindex command on transaction tables.

  and i noticed the transaction log file grows enourmous. for this i am plaaning to change the recovery mode to BULK. will this induce the probelm in the existing replication setup.

   

  thanx

• October 1, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  October 15, 2004 at 10:09 am

  #526926

  No. Changing the recovery model doesn't affect replication.