Trying to read a log file encrypted by TDE
2
votes
2
answers
491
views
I have a full chain of full backups and log backups. I am looking to investigate exactly what transaction was done by a certain user in a given period of time.
The database (thus all backups) are encrypted by TDE. Tools such as ApexSQL Log does not work on TDE-encrypted data source. Is there any way I can analyze the log file to find out the information I want?
I can run fn_dump_dblog which gives me some information, however I cannot retrieve the exact information on what was changed, such as what column was changed to what value.
Asked by elty123
(431 rep)
Jul 6, 2018, 06:07 PM
Last activity: Mar 17, 2025, 02:04 PM
Last activity: Mar 17, 2025, 02:04 PM