Re : Restore table from Transaction Log

Hi,
After I copied some views from other database, I lost all records in five
tables. Unfortunely, I didn't have the backup file.
I tried to use Lumigent to restore from the Transaction log, and three of
them have been recovered successfully. But still have two tables cannot
restore.
Anyone can share some ideas how to restore the rest two.
Many many many thanks!Hi
Copying views will not delete data or drop tables, I can only assume that
you have scripted the view and it's dependent objects from Enterprise
Manager. In which case I think you should be able to restore all the tables
using the Lumigent product.
Failing that, as you don't have a backup, then the tables must be on the
system you scripted the view from.
John
"Bevis" wrote:

> Hi,
> After I copied some views from other database, I lost all records in five
> tables. Unfortunely, I didn't have the backup file.
> I tried to use Lumigent to restore from the Transaction log, and three of
> them have been recovered successfully. But still have two tables cannot
> restore.
> Anyone can share some ideas how to restore the rest two.
> Many many many thanks!
>
>