Dear all,

In Sql Server 2000, I have deleted the data from a table by mistake, using
the "TRUNCATE TABLE" query.

Is there is any way to get back my data from the log file?

Please help me.

Regards,
Thirumalai.

Hello,

Do you have full database backup and the sub sequent Transaction log file
backups taken before the accidental truncate of table.
If you have tose then:-


1. Take a Transaction log backup from the database where u truncated the
table.

2.Rrestore the full database backup first into a new db with NORecovery
3. restore the log backps one by one using Norecovery until last backup file
4. restore the last transaction log backup using Recovery and Stopat option.
[Just before table deletion]


See books online for topic POINT_IN_TIME recovery

Thanks
Hari
SQL Server MVP



[quoted text, click to view]

TRUNCATE is not a logged operation. So if you do not have backups, including
transaction log backups, then you cannot recover the data.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]

You can use the Third party tools like Lumigent log Explorer, using which
you can recover a truncated table.
http://www.sql-server-performance.com/log_explorer_spotlight.asp

Regards Aneesh .


[quoted text, click to view]