dk98681 - Friday, June 23, 2017 9:39 AM
In that case do not restore the DMK from the source server, just create a new master key.
Copy the cert backup and its private key backup to the new server and create the cert from the backup files
dk98681 - friday, June 23, 2017 9:39 AM
Where are you seeing the difference the file path?
See below highlighted in red
CREATE CERTIFICATE Olympus_bkpcertificate FROM FILE = '\\MyShares\Projects\UploadFolder\CLM_bkpcertificate' WITH PRIVATE KEY (FILE = '"\\MyShares\Projects\SFTPUpload\CLM_bkpcertificateKey.key"' , DECRYPTION BY PASSWORD = 'MyPassword2');
dk98681 - friday, June 23, 2017 9:39 AM
CREATE CERTIFICATE Olympus_bkpcertificate FROM FILE = '\\MyShares\Projects\UploadFolder\CLM_bbkpcertificate' --path to certificate file
WITH PRIVATE KEY (FILE = '"\\MyShares\Projects\UploadFolder\CLM_bkpcertificate.key"' , --path to master key
DECRYPTION BY PASSWORD = 'MyPassword2');
It's not the path to the master key, it's the path to the private key backup file 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉