Encrypting MS SQL DBs at Client Level

[GregE]

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?

[chad_small]

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.

[GregE]

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.