Results 1 to 3 of 3
04-25-2012, 01:06 PM #1
Encrypting MS SQL DBs at Client Level
Using SQL TDP, this is from the documentation.......
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?
04-25-2012, 02:38 PM #2
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.
04-25-2012, 02:42 PM #3
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."
By EdBorden in forum TDP/Application Layer BackupReplies: 1Last Post: 03-23-2012, 06:12 AM
By mrfarvin in forum Microsoft SQL ServerReplies: 2Last Post: 10-25-2010, 12:14 AM
By umur in forum BCP / DRPReplies: 3Last Post: 11-07-2008, 04:12 PM
By spiffy in forum Backup / Archive DiscussionReplies: 1Last Post: 07-02-2008, 11:58 PM
By mark.swanston in forum TSM ClientReplies: 7Last Post: 05-29-2008, 04:18 PM