Post reply

Recovery model for subscription database

  • December 11, 2012 at 1:45 pm

    #286082

    Hello,

    We have a database being replicated to a second server where it is used strictly for reporting purposes. If it gets corrupted, no big deal, I'll just re-create it and re-synchronize the subscription.

    Currently, the subscribed database is set to Full for the recovery model and I'm trying to get disk usage down on that instance.

    Can I set the recovery model for the subscribed database to Simple? Is there anything I need to do to the subscription or publication before I do this?

  • December 11, 2012 at 1:49 pm

    #1567606

    Recovery model is determined by your recovery requirements in the case of a disaster. If you need to be able to restore to point in time, then you need full recovery. If that is not required, then you can use simple recovery.

    There is no dependency whatsoever between transactional replication and recovery model.

    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

  • December 11, 2012 at 1:56 pm

    #1567610

    Thank you! I have searched for hours and couldn't seem to find this simple tidbit of information.

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

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