THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Can you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2015/08/12/can-you-still-use-dbcc-page-to-access-data-in-dropped-tables-if-tde-is-turned-on/

Published Wednesday, August 12, 2015 11:59 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

SQL Admin said:

TDE is used to encrypt the physical files , enabling encryption will secure the physical files so they cannot be used without specific key ,

So if you attach them in a SQL instance which have the key installed they will be normally accessed , so it's obvious that you can access the pages contents using DBCC Page , however you cannot attach them in a different instance

by the way I might be wrong because I am new DBA , and currently learning

August 17, 2015 4:57 AM
 

Rob Farley said:

Yup, it's fairly obvious - but it's quite reasonable to expect that it might only decrypt pages that are part of known allocations or something like that. It's good that you found it obvious though.

August 17, 2015 5:19 AM
 

PhyDataDBA said:

Not surprised DBCC page works like this with TDE.  

TDE is supposed to present data transparently in every way to any authorized connection or process.

I would be more surprised if this did not work with TDE.

August 18, 2015 9:24 AM
 

Rob Farley said:

Right, but it's not too much of a stretch to wonder if the TDE process might only apply to data that it knows about.

August 18, 2015 5:55 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement