If your database's recovery model is full/bulk-logged you will have to do
point in time recovery. Point in time recovery can be done with the help of
combination of full/differential and transacation log backups.
Look for topic "Recovering to a Point In Time" / "Restoring a Database to a
Prior State" in Books online
"Venkatesan M" <venkat_asphotmail.com> wrote in message
news:OAMQwZHRDHA.1712TK2MSFTNGP12.phx.gbl...> hi folks,
> I have accidentally UPDATEed huge amount of data that is in a table.
> I need to rollback it....is there any way to do it using log file without
> executing another UPDATE statement.
> Thanks in advance.