• Restore your last full backup as a new database (restore with norecovery), restore all log backups taken up to the point of the accident WITH STOPAT and specify a time just before the accident. If the accident was after the last log backup, then take another log backup off the database with the missing tables and restore that WITH STOPAT and specify a time just before the accident.

    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