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 advance
Hi,
You can use POINT_IN_TIME restore if your Recovery mode for that database is
FULL plus you should have full database backup , transaction log backups.
Stes:-
1. Take a backup transaction log in current database
2. Create a new database
3. Restore with full backup file with NORECOVERY (Use below command)
RESTORE database new_dbname from disk='file' with NORECOVERY, MOve
'logical_mdf' to 'physical_mdf',
move 'logical_ldf' to 'physical_ldf'
4. Restore the subsequent transaction log backups in NORECOVERY mode.
5. Restore the transaction log backup taken in step-1 with RECOVERY and
STOPAT option
RESTORE log new_dbname from disk='tran_backup_file' with RECOVERY,
STOPAT= ''Aug 05, 2004 03:44 AM'
Date and Time should be given based on your requirement for STOPAT option.
Thanks
Hari
MCDBA
"Mark Bushnell" <markbn@.bushnell.com> wrote in message
news:ulc4sAqeEHA.2028@.tk2msftngp13.phx.gbl...
> 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
>

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 advance
HI
If you have full backup:
First backup log.
Restore db on another server with no recovery, and restore log with stopat before time of table deleted. If you don't know the correct time, you can repeat 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
>
>

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
>
>