I have a website in Azure which uses a SQL CE 4.0 database. For security reasons, I want to have a backup of the database created daily and stored for two weeks.
The database is fairly small (under 10 MB), but the website itself contains a huge folder with images, which can be up to 1 GB. The images are never modified and I want to avoid redundantly backing them up.
What is the optimal way to set up backup for such a case?