help!

hi!
accidently I deleted a table from a database that has 1200 tables. I do not
want to restore the whole database, but just the table I deleted. I backup
the transaction log every hour. What should I do?
thanks,
Hi,
Do a POINT_IN_TIME Recovery... Still you have to restore the full database
backup in to a new database followed with transaction
log backups.
POINT_IN_TIME restore will work only if your Recovery mode is FULL for that
database.
If it is FULL then:-
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 transaction log backup taken in step-1 with RECOVERY and
STOPAT option
RESTORE log new_dbname from disk='tran_backup_file' with RECOVERY,
STOPAT= ''May 24, 2004 03:44 AM'
Thanks
Hari
MCDBA
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:#FdiLZofEHA.3412@.TK2MSFTNGP11.phx.gbl...
> hi!
> accidently I deleted a table from a database that has 1200 tables. I do
not
> want to restore the whole database, but just the table I deleted. I backup
> the transaction log every hour. What should I do?
> thanks,
>