Retrieving data tables without backup SQL

Tags:
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?
ASKED: April 8, 2010  3:23 PM
UPDATED: April 9, 2010  7:15 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server Ask the Experts
    [...] Retrieving data tables without backup SQL [...]
    0 pointsBadges:
    report
  • SQL Server Ask the Experts
    [...] Retrieving data tables without backup SQL asked by  a SQL Server reader and answered by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following