Perhaps I am missing something 'Simple'...
I am running an instance on AWS RDS..
I am trying to set the recovery mode of a database to simple eg:
ALTER DATABASE [Test] SET RECOVERY SIMPLE
his works fine, and I can see the change BUT, after a few minute it reverts back to FULL?? Am I missing something?
RDS is supposed to be fully managed service, why would you want to change the recovery model when you cannot control or manage it?
😎
The only thing you could possibly accomplish would be breaking the log chain!