Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks

share|improve this question
add comment

1 Answer

up vote 2 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: meta.stackexchange.com/questions/5029/… –  splattne May 4 '10 at 20:38
add comment

Your Answer

 
discard

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.