We configured Mysql database with a backup of 30 days. As part of our ISO Audit process we were asked to show the successful data backup alerts happening every day. At the same time we were also asked to show a successful restore.
While we see that the backup is configured successfully we do not have any alerts which show that it is backed up successfully. Is there a way to configure alerts. The other problem is we need to show proof that we can restore the backed up data atleast once even if it is on a lower environment.
When we tried to do a backup we found that it is asking us to create a new server altogether to restore the backed up data, while we want to restore the data to a specific date and time in the same server (We were using Code guard service earlier using which we can perform this restoration). How do we achieve this. If this can be done only onto a new server do we have to change all the existing connections of app services to this new database? Is this how it is designed?