I have an ongoing need to provide a archival solution for an ex-production system for Regulatory reasons. In a nutshell:
- active database is around 30GB, but there will be others pending of varying sizes
- there may be the need for a couple of queries a year initially, tapering off
- potentially need to retain for 25 years
There's a number of options I could implement in our rack space but I've decided I need to roll my sleeves up and look at cloud options with long term storage, pay-what-you-use, abilities.
My question is, with Azure, what would be the best options for a long term, hardly used, archival strategy?