Backup Keys

Question

Post reply

Backup Keys

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
November 8, 2014 at 1:05 pm

#74773

Comments posted to this topic are about the item Backup Keys
November 10, 2014 at 1:47 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Here is another good reference on the topic

http://sqlity.net/en/2427/backup-asymmetric-key/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

RKaram SSCommitted Points: 1518 More actions · Answer 2

Ohhhhh!!!

I didn't see the word "individual" 😉

Good question Steve

Have a good day

Rabih

rkaram

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

SQLRNNR (11/9/2014)
Here is another good reference on the topic
http://sqlity.net/en/2427/backup-asymmetric-key/

Thanx 4 that useful link 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Stewart "Arturius" Campbell (11/10/2014)
Good question, thanks Steve.
Only ever encrypted databases using certificates, so learned something here today.

Definitely.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Good question. Whenever I create keys, I back up the SQL I use to create them. This way I know how to recreate it exactly the way it was created in the first place. Of course, that brings up the point of what to do with the plain text to create the keys, but that's another discussion.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

Ed Wagner (11/10/2014)
Good question. Whenever I create keys, I back up the SQL I use to create them. This way I know how to recreate it exactly the way it was created in the first place. Of course, that brings up the point of what to do with the plain text to create the keys, but that's another discussion.

Really this code becomes a password, and needs to be secured as such. It also complicates deployments, but that's another discussion.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Steve Jones - SSC Editor (11/10/2014)
Ed Wagner (11/10/2014)
Good question. Whenever I create keys, I back up the SQL I use to create them. This way I know how to recreate it exactly the way it was created in the first place. Of course, that brings up the point of what to do with the plain text to create the keys, but that's another discussion.
Really this code becomes a password, and needs to be secured as such. It also complicates deployments, but that's another discussion.

Agreed. The SQL to create the key is something I treat just like a password, as it's the key to decrypting sensitive data.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

SQLRNNR (11/9/2014)
Here is another good reference on the topic
http://sqlity.net/en/2427/backup-asymmetric-key/

That was a really good read. Thanks.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 9

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP