What are best practices for setting up long term retention for an Azure SQL DB? Are there any common strategies to keep the costs low? How should one go about implementing it for keeping 10 year backups.
When I select weekly snapshots for 10 years, the cost is going through the roof (3.5x the cost of the DB just for LTR) and I realized there must be a better way to store DB snapshots, either with LTR or custom solutions.
I am no DBA and I am finding it hard to find any best practices and how it should be setup and suggestions or resources is appreciated. How would it have been done on an OnPrem SQL server.