Hi Mark 🙂

If you are doing the typical once a night ETL refresh of data then a simple nightly backup work.

The Recovery Model I use is Simple as there is no transactional data that occurs or updates throughout the day. I simply take a full backup each night before the data load occurs, and IT Ops takes a nightly backup that they retain for 12 weeks so we have redundancy. If you don't have that type redundancy then you will need to decide your company's retention policy for backups, but that is the gist of it 🙂

I have been using this method for our Data warehouses for roughly 5 years with no hiccups, and it has saved a few disasters for sure.