Does truncate and drop statement clean the disk with 0s or would it be possible to recover data thro
Hi,
Our security team is asking us if using truncate or drop statements also wipes the disk.
They are interested to know if, should someone get their hands on a disk belonging to the DB, if they could use forensic methods to obtain data from a table which was truncated or dropped from the DB.
So it's possible it would be deleted from a user perspective but still available on disk until overwritten.
Thanks,
Nico