• 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.