November 4, 2019 at 4:40 pm
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?
November 4, 2019 at 4:54 pm
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.
November 4, 2019 at 5:24 pm
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply