how to undo Wrong Update Statement

unless you had a BEGIN TRANSACTION before that UPDATE, you have to RESTORE your database.

if your db is in full recovery mode:
* issue a tlog backup
* get your last full backup and all tlog backups since that last full backup
* restore to the point in time before your update.

if your db is in simple recovery mode:
* restore the last full backup.

The last back up is three days old during the that period number of editing and new update passed.
Please guide my on full recovery mode
how to check this mode and step to check time and update

check out the database properties, recovery model.

Sir, in properities I am not been able to find recovery model. Please Help how to find

run this query to see for your database:

select name, recovery_model_desc
from sys.databases

Select allOpen in new window

Result:

master      SIMPLE
tempdb      SIMPLE
model      SIMPLE
msdb      SIMPLE
ReportServer$SQLExpress      SIMPLE
ReportServer$SQLExpressTempDB      SIMPLE
DLI_DB      SIMPLE

my database is DLI_DB

no backup mode state, I was taking backup manually after deattaching database I copy and past in different location the las copy past use on 7/4/2008

as your db is in simple recovery mode, you can only do a full restore of the last full backup.

you might try some third-party tools like lumigent logexplorer, but you might already have overwritten most of the tlog file, especially with updates like yours...

could you guide me please site address.