Questions tagged [transparent-data-encryption]

Transparent Data Encryption, a feature used to provide protection for data at rest.

Filter by
Sorted by
Tagged with
0
votes
1answer
465 views

Installing SQL Server TDE on a Windows Cluster

i'm going to be upgrading two Instances to Enterprise and thenI'm going to be installing TDE on two sides of a Windows Cluster. All of the databases are on one storage device and whichever Instance is ...
0
votes
1answer
32 views

Cloning a SQL Server Virtual Machine with TDE

When a virtual machine with a SQL Server database that uses TDE is copied or cloned, will the database be readable on the new instance?
0
votes
0answers
16 views

SQL 2016 - TDE Restore Failing Even After Certificate Restore

I'm trying to ship some TDE enabled database backups from one server to another and I'm having a problem. Specifically, I'm getting the following error: RESTORE FILELISTONLY FROM DISK = N'<path>...
0
votes
1answer
84 views

Oracle 12c. Is it possible to export a TDE encrypted table using expdp / impdp to a database without TDE / wallet enabled?

I have an Oracle 12c database where I have encrypted certain columns of several tables, I want to import or load these tables into another database which does not have TDE enabled, as would be ...
0
votes
1answer
282 views

Oracle 19c cannot create master key

I cannot create master key in oracle 19c... I set parameter in sqlnet.ora like as: WALLET_LOCATION= (SOURCE= (METHOD=file) (METHOD_DATA= (DIRECTORY=/opt/oracle/product/19c/db_home/...
0
votes
0answers
16 views

Can we change asymmetric key attached to a SQL server login

I have created a login using the below command: Create Login test From Asymmetric Key asymkey1; Is there any way to alter the login and attach a different Asymmetric Key asymkey2?
0
votes
0answers
33 views

How to use tablespace

I am trying to implement Transperent Data Encryption. I am done with setting up the wallet and creating the tablespace. My doubt is how to specify tablespace so that every object(tables/functions/...
0
votes
0answers
181 views

TDE Enabled DB Always Going Into “Recovery Pending” on Secondary Node [duplicate]

I have a Windows Failover Cluster set up with SQL 2016 Enterprise SP2. TDE was implemented on a DB, on node1 the DB is able to start without issues. However, when a failover occurs, on node2 the DB ...
0
votes
1answer
46 views

using oracle tde

I am new to using oracle database. I want to encrypt data stored in oracle. I am using oracle 18c for this and using TDE(Transparent Data Encryption) feature for it. However, when I run select query ...
0
votes
0answers
928 views

Change Encryption Wallet type from PASSWORD to AUTOLOGIN

I am currently working on an Oracle 18.3 DB and I have a script which allows me to create an encrypted seed PDB. As part of this script, we encrypt the system tablespaces (like SYSTEM, SYSAUX, and ...
0
votes
1answer
58 views

Data Security in MS SQL Server

How do I store the sensitive information on SQL server?. We have policy guidelines, DBA and Development engineers are not allowed to view the data as plain text. I am aware of the encryption ...
0
votes
0answers
147 views

Enabling TDE on PRODUCTION Servers - Guidance , Suggestions and Testing TDE ways

First of all just want to say , I am completely new to Transparent Data Encryption. Can I get some guidance on things to keep in mind while I am enabling TDE on Critical PRODUCTION Servers. I have ...
0
votes
1answer
542 views

Disabling TDE on AlwaysOn database

Which are the correct steps to disable (not removing) TDE on a AlwaysOn database in an availability group? I found steps for removing TDE but that involves removing the availability group and ...
0
votes
1answer
32 views

Alternatives to User Defined Performance Counters for CPU Monitoring - SQL 2014

I want to monitor CPU usage before implementing TDE on several production SQL Servers. My plan was to use user defined performance counters, over a period of a couple of days, counters as defined ...
0
votes
1answer
481 views

SQL Server TDE with PKI - converting P12/PKX to PVK/DER format

To use TDE for SQL Server we are obliged to use a PKI certificate. The certificate has the format .p12(.pkx). Microsoft offeres a certficate converter for SQL Server. Using it - it creates three ...
0
votes
1answer
410 views

Generate the statistics of a table after truncating it and then repopulate it?

Is it necessary to generate the statistics of a table after truncating it and then repopulate it? I have a table with several million rows in Oracle.Every week new data is recharged, truncating the ...
-1
votes
2answers
389 views

oracle 10g - encrypting existing column - Transparent Data Encryption

It's possible encrypting existing column without lost and rewrite data? I've few milion of record and it's very important not lost data.
-3
votes
1answer
825 views

Disadvantages of TDE [closed]

Is there any effect at the application end, if you configure TDE for Production databases, which are in both replication and Always On Availability Groups in SQL Server 2014 Enterprise Edition? This ...

1 2
3