I'm migrating a database from
SQL Server 2012 to
SQL Server 2014 on the same server.
I'm configuring LOG SHIPPING on a database that is apparently encrypted:
When setting the log shipping I got this message (when it started to restore the database from a backup):
I'm the new DBA here and there's no report of master keys, encrypted keys etc.
I'm setting log shipping from SQL2012 to SQL2014 (with norecovery). What could go wrong if I set this database to
Encryption enabled - false and try to restore the database with the log shipping wizard?
There are some questions about this problem , like This one, but all of them say I need the password.
I Just found this certificate on
master > security > certificates on the primary server (2012):
And there are some code samples over the Interet but I really can't trust them (I don't think it's too simple):
`USE MASTER GO ALTER DATABASE DatabaseName SET ENCRYPTION OFF GO USE DatabaseName GO DROP DATABASE ENCRYPTION KEY GO`
In this question Dylon says:
If you are receiving the thumbprint error the certificate was not created properly from the Source Server's Cert/Key backups.
I'm confused about this topic and all I want is to disable encryption, restore the database on the other server to log shipping, and some day, activate encryption.
Database > tasks > manage database encryption there are some options too:
Disabling this, I would be able to backup the database again, and restore it on the new instance?