Backup command not reading contents of the encryption file
we have been using backup encryption for a while, we have one specific cluster where the file containing the encryption file is not being read, instead, the password used to encrypt the backup is the name of the file.
This is the code we use:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASES [msdb] TO DISK = [\sql_backups<AUTO>_encr.sqb] WITH PASSWORD = [ FILE:C:EncryptionDCR.txt ] , KEYSIZE=256, COMPRESSION = 2, ERASEFILES_ATSTART = 30, MAILTO_ONERROR = [[email protected]] " ', @exitcode OUT, @sqlerrorcode OUT
The contents of file c:EncryptionDCR.txt is what we use as password.
The backup executes fine, but the encryption key is set to "C:encryptionDCR.txt" instead of the contents of the file.
This is running the same way across the rest of the sql clusters, but we don't have these issues in any other but this cluster.
We can't figure out what's wrong with this particular one. The sql backup version on this server is 184.108.40.206.