I need to recover deleted data from an SQL Server 2000 transaction log file. The Log file is 3.3GB. I tried the usual SQL Log Rescue but it keeps crashing with outOfMemory exception. I also tried it on different machines with the same error.
I tried ApexSQL Recover, seems to work, but it's a trial so only every 10th row is shown. I may have no choice but to shell out 999.00 for this tool, if I cannot find a cheaper solution.
EDIT - If I try to restore from backup and then replay my log file, can I restore the backup to a different database (new) on the same server?