1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

TSM and SQL 2008 using Enterprise Encryption

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

  1. chad_small

    chad_small ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    46
    Occupation:
    AIX/SAN/TSM
    Location:
    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.

    :confused:

    Chad Small
     
  2.  
  3. Eldoraan

    Eldoraan ADSM.ORG Senior Member

    Joined:
    Feb 19, 2003
    Messages:
    288
    Likes Received:
    10
    Occupation:
    Data Protection
    Location:
    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