Changing Recovery Model

• Nitin Rana-182398

  Say Hey Kid

  Points: 687

  More actions

  November 3, 2004 at 6:29 am

  #86785

  I have transactional replication enabled and now I want to change the recovery model on published database. Do I need to stop the replication?? If not, what is the correct procedure to do it.

  Thanks in advance.

• November 8, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  November 8, 2004 at 8:13 am

  #529317

  When you say change the recovery model, from what to what?

  I don't think you need to mess with replication. If you are moving from simple to full, you need to take a full backup after the change.