recover deleted entries from ztable

[Former Member]

Hi

is there any best method to recover the deleted entries from ztable?

[former_member583013]

Deleted entries can't be recovered....If you made a COMMIT WORK they're totally gone....

Greetings,

Blag.

[Former Member]

Best method is to log table changes OR create an extra field on the table called "marked for deletion", for example. When a user "deletes" a record, this field gets set to an 'X' - for example.

[Former Member]

Hi ,

There is no way to rcover the entreis, ones entries are deleted.

and before deleting the entries try to be bit careful and after ensuring with ur leads only , exceute ur code.

Regards,

Naveen

[former_member195930]

Hi Vahi,

1. Find out the exact time when the data has been deleted.

2. Restore THE WHOLE DATABASE on any other server with MSSQL server

running on that. You should not restore the database completely,

rather using "Point-in-time" recovery method. Appoint the time from

the p.1 minus 5 minutes as the end point of the database recovery.

Please refer to the note 193816 for more information.

3. Now the old content of the table ZRATE is there. You can

export the data and then import them into the produtive system.

Afterwards you can delete the restored database, it is not needed

anymore.

Thanks!

Anusha

[Former Member]

LOL - Very funny!!

[former_member583013]

You can backup your tables with this -;)

<a href="/people/alvaro.tejadagalindo/blog/2006/03/16/taking-good-care-of-z-data good care of Z Data</a>

Greetings,

Blag.