We have "AdfsConfiguration" and "AdfsArtifactStore" databases for our ADFS deployment. I keep running into disk space issues due to the full and transaction log backups being taken on the server.
Right now, these two databases are in Full recovery model - but I wonder if I can just switch to Simple. Are transaction log backups going to be important in these two databases?
I have searched a lot but can't really understand whether these DBs need actually need the trans log backups or if just a nightly full backup is good enough.
Also, I understand the general rules of thumb for deciding between the two models (SIMPLE or FULL recovery model for databases?) for I just can't come to and understand on what these ADFS databases are really doing to make the decision.
This is a screenshot of the "restore" GUI screen. it shows how I have log backups taken every 30 min:
This basically means our RPO is 30 min? And then the full backup ensures ALL previous transactions are recoverable if they occurred before it was taken (in other words... I don't need to have log backup files from before the point in time in which the full backup was taken, right?)
I am not using compression (only available in Enterprise Edition right?)
I have thought about daily DIFFs and weekly FULLs. I honestly just seem to read online of a lot of people doing nightly FULLs. All instances I inherited were already set up to do nightly FULLs and I haven't seen any that do daily DIFFs (not that this means I shouldn't make a change of course).
Honestly I'm one of those "accidental" DBAs (am more of a developer). It's been overwhelming to actually try to get up to speed on everything I need to understand and put into practice.