Encryption of trasaction logs

Is it possible to encrypt the transaction log during log shipping? How?

While there is no explicit log encryption in SQL Server 2005, any entries that are encrypted will be treated as binary data so it will remain encrypted during log shipping as well.

We do plan on offering enhanced encryption features for SQL Server 2008, we will post any further info as soon as they are publicly available.

Hope this helps, please let us know if you have any further questions.

Sung

|||is there any third party utilites that support encryption that are supported by Microsoft ?|||

Hi,

I'm not currently aware of any third party utilities that are supported by Microsoft. We may have a few partners that we perhaps recommend. I am currently checking up on this and will post any info that I find.

UPDATE: While we don't have any specific recommedations in this space, we do have a large number of third parties who have developed solutions in this area. They would be the ones who would directly support any solutions that they may have. Please contact software vendors to discuss any options that they may have or perhaps may provide.

Thanks,

Sung