Search results for "tde"

Your search for "tde" returned 100 results:

Technical Article

TDE enabled but database backups don't *appear* to be encrypted

  • Topic

I have a database that is using TDE and this can be confirmed through:This returns: However after a backup, checking the values in msdb.dbo.backupset suggests that the backup hasn't been encrypted:This returns: Is this indicating that the backup hasn't been encrypted? This appears to contradict the Microsoft article regarding TDE (https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-2016):If the backup is being […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-05-24

22 reads

Technical Article

TDE & CLE certificates + key files: store in Azure Key Vault?

  • Topic

Environment: Win2008 R2 / SQL Server 2008 R2 SP3 on Azure VM (IaaS)Issue: Can I store TDE and CLE certificate and private key files in Azure Key Vault. So far I have set TDE and CLE in one database. I have then backed up the associated cert/key files locally. I have then used powershell to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-06-14

255 reads

Technical Article

Questions about TDE (Transparent Data Encryption)

  • Topic

I have been investigating about TDE since a couple of days and have come across these following questions. Please help me seek clarity on these. Thanks. 1. Do I have to backup the Service Master Key? If yes, why? 2. Do I have to backup the Database Master Key? If yes, why? 3. Where the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-04-12

74 reads

Technical Article

Known issues with TDE.

  • Topic

We are planning to enable TDE on some of our databases. And, I need to make all the loopholes have been covered before this major step. I am aware of some of the known issues (limitations) of TDE. (CPU intensive, encrypted tempdb causing performance hit for non-TDE dbs etc.) There are also some issues with […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-08-12

360 reads

Technical Article

Large transaction log backups

  • Topic

Hi Experts, Have some question related to large transaction log backups. We have one big database called "RepositoryDW" which is of 4TB size. It has TDE enabled recently. Backup compression enabled at instance level. After enabling TDE we see a behaviour like the size of log backups are very large sizeing from 80GB - 160GB. […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-12-29

199 reads

Technical Article

Questions on Implementing TDE

  • Topic

I am planning to implement TDE on our Database servers and I have the following questions on TDE. I tried moving a TDE database to another server. I only needed a backup and restore of Certificate and the Private key associated with the Certificate. I did not restore a backup of DMK(Database Master Key) on […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2014-08-05

51 reads

Technical Article

TDE useful on 4TB database?

  • Topic

We're being pushed by a prospective customer ( bank ) to add TDE ( Transparent Data Encryption ). PII ( e.g. social security ) columns are already encrypted with Safenet. I'm wondering how useful this is when the sql backup is 900GB compressed. Is that at risk for theft? Also, we rarely create such a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-12-08

18 reads

Blogs

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs

Forums

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers