Rollback TRUNCATE – Script – SQL in Sixty Seconds #105


One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES, let me explain the entire process with example and video.

Let me confess first that when I started my career with SQL Server, I even believed that truncate operation can’t be rolled back. The reason behind this belief was that I had always heard this from others. The matter of fact, I have even blogged like that before which I eventually corrected. However, one day, I decided to try out the entire process and to my surprised