We have a transfer batch for reapplying organization between 2 db servers (prod to staging). This batch recovers a backup of the prod database, exchanges it with the database currently in staging and restores the organization. A second part restores the encryption key.
This batch has always worked until now, however, we moved the production SQL instance to a new server and since then the encryption key not recognized anymore on the staging server even though the databases are the same.
We performed several checks: Copy key manually, deactivate SSL checking but nothing happens, the key is not recognized. Checking if the user belongs to the PrivUserGroup.
Are there any other possible checks? Do you know what this encryption technology in SQL Server is based on?
Thks,