1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TSM and SQL 2008 using Enterprise Encryption

Discussion in 'Microsoft SQL Server' started by chad_small, Aug 27, 2009.

  1. chad_small

    chad_small Moderator

    Dec 17, 2002
    Likes Received:
    Gilbert, AZ
    Anyone know if the TDP for 5.5 supports SQL 2008 when the DB is using enterprise encryption? If so how is does the encrypted DB affect the TDP and its performance? Is the data sent to TSM encrypted? I figure it isn't but not sure. I don't see anything in the 5.5 manual and google searches aren't getting me far.


    Chad Small
  3. Eldoraan

    Eldoraan Senior Member

    Feb 19, 2003
    Likes Received:
    Data Protection
    Charlotte, NC
    From what I've been able to determine, the TSM client/TDP client will pull the data through OS/App API and send to TSM in the clear. Same thing happens when you use drive encryption at OS level. I know it's pretty easy to do client encryption with BA client, not sure what's involved with the TDP packages. I would imagine decrypting stream from DB to TSM API then reencrypting to TSM server would slow things down quite a bit.

    I've spent last several weeks testing various encryption methods (AME, LME so far) with potential need to start testing client based. I'll know more on this myself in another month or so. :)

Share This Page