Changing Recovery Model in Replicated Database
Posted
by Rob
on Server Fault
See other posts from Server Fault
or by Rob
Published on 2009-11-18T13:35:02Z
Indexed on
2010/03/26
23:03 UTC
Read the original article
Hit count: 395
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
© Server Fault or respective owner