Is it possible to Retrive Deleted Data using Log file in Sql
server

Hi, 

Is there any way to Retrive Deleted Data using Log file in Sql server.

 

Thanks 

Mayur Panchal

There is a log... but I'm not sure it will do any good.

Anyway, to give you some hope, try this link:
http://forums.mysql.com/read.php?88,68282,68315#msg-68315

Though, honestly I don't think there is much you can do to recover the data
without hiring a specilist which isn't cheap. 

For future reference I would create a task scheduler event to automatically back
up the database every day, or hour.  Plus always back up information before you
start programing.  You can probably just do this with a simple batch file.

If you want to, you can also invest the time to emulate window's deleting
method, by adding a column to the table for "DeleteState" and set it
as a tinyint(1) for 1 or 0.  That way information is always kept for those
"just in case" purposes.

Another good idea is an idea I'm playing with for my site, is creating an
"action" table.  Which will basically create an interactive history of
commands that can be executed in the future to recover information.  Though
there maybe some security/integrety risk involved that will need to be worked
out.