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.

Encrypting MS SQL DBs at Client Level

Discussion in 'Microsoft SQL Server' started by GregE, Apr 25, 2012.

  1. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    Using SQL TDP, this is from the documentation.......

    enableclientencryptkey
    This option encrypts SQL databases during backup and restore processing.
    One random encryption key is generated per session and is stored on the
    Tivoli Storage Manager server with the object in the server database.
    Although Tivoli Storage Manager manages the key, a valid database must
    be available in order to restore an encrypted object
    .

    What does that bold line mean? Does this mean a shell SQL DB must exist to restore into?
     
  2.  
  3. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    You must have access to the TSM DB to restore the data. In other words the TSM DB backup has to be current for the data to be ale to be restored. Technically its the same requirement of easily restoring any data from TSM. You have to be able to connect to a TSM server to get your data back.
     
  4. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    Oh. That's odd. I thought that MIGHT be what it meant, but then thought...."nah, can't be THAT because OF COURSE I need the TSM db to restore data."

    Thanks Chad.
     

Share This Page