Rohit Kumar
Can you recover truncated data in SQL SERVER?
Posted by Rohit Kumar in SQL Server on Dec 02, 2012
  • 0
  • 4
  • 4627
Do you know the answer for this question? Post it below.
Guest
Posted by Niks Bisht on Mar 06, 2013
  • 0

While database is in full recovery mode, it can rollback any changes done by DELETE using Log files. TRUNCATE can not be rolled back using log files in full recovery mode.

DELETE and TRUNCATE both can be rolled back when surrounded by TRANSACTION if the current session is not closed. If TRUNCATE is written in Query Editor surrounded by TRANSACTION and if session is closed, it can not be rolled back but DELETE can be rolled back.

Posted by Malik Murad Al Ali on Dec 16, 2012
  • 0

Email me your complete system details

Posted by sarath kumar on Dec 15, 2012
  • 0

Possible when session is not closed.. If Session is closed means it not.



BEGIN TRAN

TRUNCATE TABLE TableName

-- Following SELECT will return TestTable empty

SELECT *

FROM TableName

-- Following SELECT will return TestTable with original data

ROLLBACK

Posted by swayanajyoti pati on Dec 13, 2012
  • 0

we can deallocate the truncate data in sql server


Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS

PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
2014© C# Corner. All contents are copyright of their authors.