One of our clients requires that at the end of the contract we "securely" delete all data from the server (including SQL Server).
I think I need to deal with this in two parts.
1. SQL Server Data: The client data is stored in 2 SQL Server databases, but other contracts (that are not ending) are also maintained in these databases.
Assuming that we destroy the database backup devices, if I perform
TRUNCATE TABLE is the data in any way recoverable? Assuming no, if I updated every row/column in the database with 0s, then perform the truncate, does this prevent recovery?
2. Files: We receive data-files that have been transferred onto the server and then imported into the SQL Server, and the server also generates PDF reports that physically sit on the server. Plus we have the backup files.
Are there tools or steps I can take to permanently delete this data without formatting the drive (and then using a tool like DBAN)?