Monday, March 12, 2012

How to recover a deleted table

Hi
We accidentally deleted a table of a DB and we have the log. Is there any
way to recover ? (without using log explorer from lumigent)
Thanks in advanceHI
If you have full backup:
First backup log.
Restore db on another server with no recovery, and restore log with stopat b
efore time of table deleted. If you don't know the correct time, you can rep
eat this with approach to expected time.
Copy table and data to original database.
Andras Jakus MCDBA
"Mark Bushnell" wrote:

> Hi
> We accidentally deleted a table of a DB and we have the log. Is there any
> way to recover ? (without using log explorer from lumigent)
> Thanks in advance
>
>

No comments:

Post a Comment