Results 1 to 3 of 3
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default Encrypting MS SQL DBs at Client Level

    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. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,194
    Thanks
    1
    Thanked 26 Times in 25 Posts

    Default

    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.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    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.

Similar Threads

  1. Encrypting backups with TDP for SQL Server
    By EdBorden in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 03-23-2012, 06:12 AM
  2. How to encrypt TDP SQL DB backup with key like file level?
    By mrfarvin in forum Microsoft SQL Server
    Replies: 2
    Last Post: 10-25-2010, 12:14 AM
  3. Encrypting backupsets
    By umur in forum BCP / DRP
    Replies: 3
    Last Post: 11-07-2008, 04:12 PM
  4. Oracle DBs and SQL BACKTRACK and TSM
    By spiffy in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 07-02-2008, 11:58 PM
  5. Replies: 7
    Last Post: 05-29-2008, 04:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •