How we can rollback the TRUNCATE operation?

Fahad Khan

7y796SQL

Hi everyone,

as the difference B/T delete and truncate that

delete command can be rollback while truncate cannot be rollback.

so i notice a thing while reading an article that

"We can rollback the TRUNCATE operation by using the TRANSACTION"

How?

help will be appreciated

Thank you

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Accepted answer
Hi.
We can rollback the Truncate Operations.
Here is an example,
BEGIN TRANSACTION;
  SELECT * FROM [dbo].[Demo];
  TRUNCATE TABLE [dbo].[Demo];
  SELECT * FROM [dbo].[Demo];
ROLLBACK TRANSACTION;
SELECT * FROM [dbo].[Demo];
For more you can follow this article,
https://sqlperformance.com/2017/04/sql-performance/performance-myths-truncate-rollback

If it helps mark as answer.
Thanks.
Fahad Khan7y ago
Hi,
Thank You for the help. you guys are awesome
Thank you once again
Madan Shekar7y ago
What does it actually means and how ? using BEGIN TRAN... ROLLBACK, you can rollback both DELETE & TRUNCATE. and without that both will get committed and cannot be rolled back. So what I got was the only difference might be w.r.t. the restore process by logs i.e. restoring the backups with point in time recovery. But then also while recovering to a point, the data should remain same at any given point of time be it DELETE process or TRUNCATE process. May be i'm missing something or have landed in confusion zone.