Backups - which email?

The email goes to the user they requested the backup.

If you’re self hosted then the file is available on your server in /var/discourse/shared/standalone/backups/default

If you’re using s3, then it’s there.