TDE and Backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » TDE and Backups

24 posts, Page 1 of 3

1 2 3 »»»

TDE and Backups

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Wednesday, August 10, 2011 8:59 PM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

Comments posted to this topic are about the item TDE and Backups

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1158172

L' Eomot Inversé

Posted Wednesday, August 10, 2011 9:02 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:54 PM
Points: 7,078, Visits: 7,120

Nice clear and unambiguous question.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1158174

dawryn

Posted Thursday, August 11, 2011 1:36 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:41 AM
Points: 1,944, Visits: 572

Tom.Thomson (8/10/2011)

unambiguous question

Oh, what is a normal backup Ermm

a backup before TDE was enabled or backup following standard procedure Blush

Post #1158218

Koen Verbeeck

Posted Thursday, August 11, 2011 1:36 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,367, Visits: 6,463

Nice question, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1158219

Stewart "Arturius" Campbell

Posted Thursday, August 11, 2011 2:27 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:49 AM
Points: 3,123, Visits: 4,310

Nice simple question.
thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1158245

paul s-306273

Posted Thursday, August 11, 2011 2:28 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:24 AM
Points: 1,158, Visits: 642

Thanks Steve.

Post #1158247

mohammed moinudheen

Posted Thursday, August 11, 2011 2:55 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

I got confused with the question and got it wrong. I thought that the normal backups which Steve was referring to might be the backups for databases without TDE enabled. I guess there might be a few who thought like I did.

Mohammed Moinudheen

Post #1158266

rfr.ferrari

Posted Thursday, August 11, 2011 5:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

nice question!
thanks steve!!!!

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1158366

m mcdonald

Posted Thursday, August 11, 2011 5:57 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:17 AM
Points: 882, Visits: 585

From the referenced article...

Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery. The DEK is a symmetric key secured by using a certificate stored in the master database of the server or an asymmetric key protected by an EKM module.

....

Note

When enabling TDE, you should immediately back up the certificate and the private key associated with the certificate. If the certificate ever becomes unavailable or if you must restore or attach the database on another server, you must have backups of both the certificate and the private key or you will not be able to open the database.

From the article, I didn't consider DEK == certificate

Post #1158377

Thomas Abraham

Posted Thursday, August 11, 2011 6:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,146, Visits: 1,448

Seemed like a no-brainer, as I thought that was the purpose of "at rest" data protection. But, I've seen the issues posted above. Some day we'll all converse in an arithmetic language and ambiguity will be a things of the past ... unless we aren't all using the same encoding....

Please don't go. The drones need you. They look up to you.

Post #1158386

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions