• That code will only recover deleted records that are still in the active portion of the transaction log (ie deleted since the last log backup or checkpoint). Since you want rows deleted back in January, that code would not work for you anyway.

    There is no way to recover deleted records in SQL Server. If you need to know what rows were deleted in a particular period and you have no auditing, you will need to restore backups from before and after the period you are interested in and compare the data.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass