How to roll back delete operation sql server? [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

开发者_如何学Python

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 9 years ago.

Improve this question

I have an input page in my C# application whereby my boss can enter sales info.

This page also has a clear button, which clears the contents of the table in the database. This clear button was convenient for testing, however now in hindsight a mistake.

All the records in the table have been deleted. There are no backups either.

Long shot, but is there any way of recovering this data using only SQL Server 2008?

---

If you still have the transaction logs, there are some tools, but these will cost some ...

See How to undo a delete operation in SQL Server 2005?

and https://web.archive.org/web/20080215075500/http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html

Edit : Looks like Redgate is SQL 2000 only. Which leaves Apex. And if your clear function uses TRUNCATE, you are up the creek.

---

Edit:( 2008 support)

SQL Data Compare Professional

This version of SQL Data Compare, you can compare a live database with or against backup files and synchronize data and deleted tables with their data contents from the backup file or backup file set to the live database.

Redgate even say this should do the same job, and that is why they have not come with any new version.

Will probably need a backup or transaction log ....

---

See this subject.