How do i rollback in sql server 2005

Question

My database recovery mode is seted in simple mode. and i did a update operation to set a field but all fields are updated with that value. i don't have any previous backup also. how can i recover to previous state before doing update operation? help me with this as early as possible.
thank you
gkm ifat

Answer 1

I dont think you can get back your data. Since you are not out of scope since there is backup for the db.

---

Vidhya Sagar. Mark as Answer if it helps!

Answer 2

Is there any third party or sql server recovery tool that can help. with out have full mode is there any way to get the data from log file?

Answer 3

I don't think we have anything as required in your case . You may also have a look at LOG EXPLORER but i am not sure to which extent it can help you without the Db being set in FULL recovery mode.

---

Thanks, Leks

Answer 4

The transaction log doesn't clear the contents of the log (simply marks the virtual log files as reusable or not), so it's possible that the data is still in the transaction log.  This assumes that there hasn't been sufficient write activity in the log since the problem occurred to wrap around and overwrite these log records.

However, given that your question is now 5 days old now, I don't hold out much hope for the log records still being in the file.  Even if you immediately stopped SQL Server and made a copy of the LDF file, you'd need to know the internal structure of the transaction log, and to be able to locate the rows.  It would be possible, but it'd be expensive to get someone to do!  As Lekss said, I'm not sure if a log explorer tool would have the smarts to read log records that are marked as "not there".