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.
Any ideas?
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?
DELETE
command unless aWHERE
clause is executed (even if it'sWHERE 'a'='a'
, because at least that forces the user to admit they're being destructive)DELETE
statement without aWHERE
clause more than once, it's their own fault.