verify to a client that their data has been deleted securely and cannot be recoveredWhat do you use (tool) to display the content of the drive that used to host your database and display that in a low-level to client in order to assure the destruction of your database? I was thinking about a carved up drive (shared) space in your SAN that can be easily used for your DB and also get destroyed and replaced by another (with the same drive letter) may be a good solution. Especially when the destroyed or release drive letter's space is returned to the pool without a trace. And, of course the new provisioned space would be blank. I am not a network engineer but something that I am thinking out loud.
sp_msforeachtable 'truncate table ?'
is not going to be sufficient. By the way, please be careful with this command as once it starts you cannot stop it without any data-loss. :) So, even then, the actual meat is still on the platter, so to speak. So, possibly having a dedicated drive / space and its disconnection from production for sole purpose of destruction would be a better choice at this level.
Just to verify and confirm; when you say 'securely' deleting, are you referring to SQL server deletion process or the residue in the file system (OS)? Deletion should have removed the LDF and MDF, right? Do you still see them files?
John E