Determine which encryption key was used for a backup.
Recently I discovered that our monthly backup has been using the wrong encryption key. I still have the pass-phrase for the key that was used, so I can recover the data, but now I am wondering how many other month end backups were ran under the wrong key.
Is there any way to determine which key was used for a backup? I have searched the job logs (the logs on the server and the ones that were emailed to me), but I cannot find out which key was used.
Any advice is welcome.
Thanks in advance.
I don't think there is a way to find out which key is used. The only way that I know of is to delete the key and then try to restore from an encrypted backup. If the deleted key is used to encrypt the backup, then you would be prompted for the passphrase.