Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I now am the proud owner of two servers that replicate with each other. I had nothing to do with the install, but (of course), now i have to support the databases. Both databases are in the Simple recovery model, but the users want to ensure as little data loss as possible so I'm thinking that I should change the recovery model over to full and start doing transaction log backups.
I wasn't planning on backing up the subscribing database, only the publisher. Is this the right plan?

Do I need to switch both the Subscriber and and the publisher to Full, or can I leave the subscriber in Simple, but have the Publisher in Full?

When I change the recovery model in one (or both) do the databases need to be offline?


share|improve this question
up vote 3 down vote accepted

no issue. recovery model will not impact Transaction replication.

share|improve this answer
Vinay, thanks for participating in Stackoverflow! Had to remove the signature from your posts. Please see:… – splattne May 4 '10 at 20:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.