Hi I follow each and every steps and final output is given below:
USE SQLEmployees
GO
BACKUP CERTIFICATE [MyServer_Cert] TO
FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\MyNewCert.cer'
WITH PRIVATE KEY(
--DECRYPTION BY PASSWORD = 'encryption',
FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\MyNewCert.pky',
ENCRYPTION BY PASSWORD = 'encryption')
But still my doubt is not clear. I didn't found certificate in the given path and if my database encryption is on then why it is opening simply. I mean if it is encrypted then it should ask for decryption while I used to open my database.
Thanks