• There is no chance of recovering anything. By truncating the log you discarded log records and told SQL that you were not interested in retaining log records any further. Additionally, a log chain has to be intact to recover. By discarding log records you broke the log chain and hence, even if the log records post that 8pm were retained (which they weren't), they'd be useless for recovery because of the missing log records.

    The best you can do at this point is to restore to the Thursday backup. All data from friday has been lost because of the log truncations. I suggest in future you reconsider your backup and log maintenance strategies. This may be worth a read - Managing Transaction Logs[/url]

    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