• Have a look at Red Gate's SQL Log Rescue. It will restore your table based on the transaction log and earlier backups. It is a free tool and it works with 2000 only.

    Disclaimer: I work for Red Gate, and I wrote the engine of the tool in question.

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software