• So to Clarify, I should be creating a new certificate 1st, Taking a backup, then If I need to replicate on other servers use the back up and that this has absolutely nothing to do with the Certificates that I installed through MMC.

    CREATE CERTIFICATE NameOfCert AUTHORIZATION [dbo]

    WITH SUBJECT= 'UserName'

    ,START_DATE= '2014-01-01'

    ,EXPIRY_DATE= '2015-01-01'

    BACKUP CERTIFICATE [NameOfCert ] TO

    FILE = 'E:\PATH\NameOfCert .cer'

    WITH PRIVATE KEY(

    FILE = 'E:\PATH\MyNewCert.pky'

    ,ENCRYPTION BY PASSWORD = 'P@$$w0rdt0EncryptCertb@ckup')

    --SEPARTATE SCRIPT TO INSTALL\RESTORE on new server

    CREATE CERTIFICATE [MyNewCert] AUTHORIZATION [dbo]

    FROM FILE = 'E:\PATH\NameOfCert .cer'

    WITH PRIVATE KEY (

    DECRYPTION BY PASSWORD = 'P@$$w0rdt0EncryptCertb@ckup'

    , FILE = 'E:\PATH\MyNewCert.pky'

    )

    Do I ever need to use?

    CREATE SYMMETRIC KEY <'key name'>

    WITH ALGORITHM = AES_256

    ENCRYPTION BY <'certificate name'>