• Lynn Pettis - Friday, January 20, 2017 9:28 AM

    Not really helpful.

    If you delete data from a table would sp_clean_db_free_space satisfy a requirement that the data could not be recovered by forensic tools.  I am starting to think no and our best bet would be to migrate good data to a new database leaving questionable data behind in the source database.

    I found myself thinking about this and my brain started going down the road of DBCC PAGE and DBCC WRITEPAGE.  It was a scary place. 😉  I'm not sure where to go from here, but it's an intriguing line of thought, albeit a dangerous one.  My initial thought is that this is not a good line of thought.  I guess I have something to think about over the weekend. 😀