Always On Recovery Models

  • RonMexico

    Hall of Fame

    Points: 3340

    It is my understanding that in order to use Availability Groups then each database to be included must be configured as full recovery model. The environment I'm dealing with has always used simple recovery mainly because there isn't a need for point-in-time recovery. Is there a way around having to take log backups while using full recovery or a way to make simple recovery work with AG?

  • John Mitchell-245523

    SSC Guru

    Points: 148761

    No, I think Full recovery mode is mandatory - it says here.  Dealing with transaction log backups isn't too much extra admin, although I suppose you will need a little extra disk space (unless you back up to a null device, which I don't recommend).

    John

  • RonMexico

    Hall of Fame

    Points: 3340

    I could easily set up a job to run every 15 minutes or so. I was more curious to see if there are any known workarounds since we aren't concerned with using the transaction logs.

  • muthukkumaran Kaliyamoorthy

    SSCoach

    Points: 19025

    RonMexico wrote:

    It is my understanding that in order to use Availability Groups then each database to be included must be configured as full recovery model. The environment I'm dealing with has always used simple recovery mainly because there isn't a need for point-in-time recovery. Is there a way around having to take log backups while using full recovery or a way to make simple recovery work with AG?

    From your post, looks like data loss is acceptable, then configure t-log every 5 minutes and delete it based on the free space .

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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