Home > IT Answers > Database > Retrieving data tables without backup SQL
SQL Server Ask the Experts
2,585 pts.
 Retrieving data tables without backup SQL
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables
If I truncate a table without the backup of it, how do I retrieve the table data?

Software/Hardware used:
ASKED: April 8, 2010  3:23 PM
UPDATED: April 9, 2010  7:15 AM
RELATED QUESTIONS
Answer Wiki:
You don't. If the database is in full recovery, and you still have the log you can try using Lumigent's Log Explore or Quest's LiteSpeed to roll back the transaction and see if it will give you back the data. I'm 99% sure that it won't. I'm pretty sure that you have lost the data. If the database is in simple recovery mode, then the data is lost.
Last Wiki Answer Submitted:  April 9, 2010  7:15 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _