I'm using SQL Server 2016 to manipulate some large research data-sets.
I keep setting the recovery mode to simple, however it keeps reverting somehow back to full. Any guidance or advice on how to make the change permanent?
The data are low value, easily reproducable, etc. so there's no need for full recovery.