Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) sp_clean_db_free_space RE: sp_clean_db_free_space

  • January 20, 2017 at 10:32 am

    #1924108

    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.

    OK, so I had to dig deeper. 
    I can't explain it better than - http://michaeljswart.com/2015/05/its-hard-to-destroy-data/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle