MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1450

One thing about TRUNCATE.... truncate is actually a minimally logged command.  Page deallocations are recorded.  It's possibel to recover from a TRUNCATE if it's done quickly.

 Here's an example

create table mytable (id int identity)
go
insert into mytable default values
insert into mytable default values
insert into mytable default values
insert into mytable default values
insert into mytable default values
go
begin tran tran1

truncate table mytable

rollback

select * from mytable

no

Of course it can.  Page deallocations are recorded.

 From the 2005 BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/3d544eed-3993-4055-983d-ea334f8c5c58.htm 

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.
 

There's no guarantee it will work but if done quickly (like, right after the table is truncated as in the sample I supplied) it can actually be done. 

aprato,

Agreed TRUNCATE is a minimally logged operation as well as under the code scenario you provide and/or with vendor tool the data can be recovered. 

Thank you for pointing out those items.

Thank you,
The MSSQLTips.com Team

Aprato, Yeah Agreed . Thanks for your valuble info