We use sqlbackupandftp to backup our MSSQL databases. I want to also ship these backups to an external server or backup provider.
Is there a way to do this via FTP whereby the source only had write permission and could not modify or delete the saved data in anyway?
I need to ensure the backups are tamper proof should the server ever be compromised. I've tried Amazon S3 with file versioning enabled but there is no way to auto expire files when this feature is enabled.