Post reply

Replication Subscriber & Recovery Model

  • December 4, 2013 at 5:42 am

    #301047

    I have transactional replication setup on one database on a 2008R2 server.

    The subscriber is in FULL recovery mode, even though we don't need it to be.

    Im pretty sure I can change this to SIMPLE without any adverse effects but just wanted to check that here before I do.

    So:

    -Can I change a subscriber database to SIMPLE recovery mode, without affecting replication?

    Thanks!

  • December 4, 2013 at 5:50 am

    #1670670

    Recovery model has no effect whatsoever on replication, that goes for publisher and subscriber alike.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply