• alex.thompson (8/16/2012)


    Could you elaborate on your bullet point about TDE not encrypting databases used in replication topologies? I'm thinking specifically of log-shipping.

    Replication does not replicate the database encryption calls, they have to be made manually.

    Log shipping is not replication. See the following extract from Books Online

    SQL Server Books Online


    If a database is being used in database mirroring or log shipping, both databases will be encrypted. The log transactions will be encrypted when sent between them.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉