Legal Issues Regarding Deletion of Records in SQL Server 2008 [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

How can I securely destroy so开发者_运维知识库me data using sql server 2008 ? (using DoD secure wipe or an equivalent)

We have a requirement for a feature that has legal implications. When we delete records from SQL Server (2008 in our case), the deleted records need to be irrecoverable from SQL Server as well as from disk. I'm not that concerned from the SQL Server side, but I'm more concerned at the disk level.

I know there are tools to do secure erasing on disk, but how can you tie that in with deleting records in a database?

My guess is that periodically or at night, a task would have to run the secure erase tool.

Any thoughts, suggestions?

---

Maybe putting the SQL data on an encrypted disk would help? After shutting down the server machine no one would be able to recover anything from the disk given the encryption is securely implemented.

If you have enough CPU power you do software encryption. Otherwise there are classical HDDs and SSDs which offer encryption in hardware.

Your description doesn't include enough details to know whether this is an option for you. Just a suggestion for the case you could apply encryption.