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: 447
        
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