when I tried to backup the master key and certificate it gives me following error.
USE master
GO
BACKUP CERTIFICATE SQLServerTDECertificate
TO FILE = 'C:\CERT\MySQLCert'
WITH PRIVATE KEY (file='C:\CERT\MySQLCertKey',
ENCRYPTION BY PASSWORD='!@chennuio89*()as@!')
Msg 15581, Level 16, State 3, Line 2
Please create a master key in the database or open the master key in the session before performing this operation.
and when tried to create master key with following query
USE master
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD ='!@chennuio89*()as@!'
GO
Msg 15578, Level 16, State 1, Line 1
There is already a master key in the database. Please drop it before performing this statement.
Need a help please.