Recover delete the row from a table?

In SQL server 2000, one of co-work delete the row in a table. How can I
recover the row.
Thanks,Do you have transactional log backup and you know the time he deleted the
record, if so ,create a dump database
restore full data base to the dump
restore differential log to the dump
restore log with stopat option to the dump
and then copy the record from dump database to the real
other wise.. use a a tool called Lumigent log explorer
vt
"Mahendra" <Mahendra@.discussions.microsoft.com> wrote in message
news:CC884D41-EE2A-4557-8202-3219CAB42EA4@.microsoft.com...
> In SQL server 2000, one of co-work delete the row in a table. How can I
> recover the row.
> Thanks,|||Hi,
You can recover the deleted rows by doing a POINT_IN_TIME recovery on to a
new database.
The POINT-IN-TIME recovery will work only if the source database's Recovery
model is set to "FULL" and you should
have a full database backup + subsequent transaction log backups.
Steps:
1. Perform a transaction log backup of the original database (If you have
not performed one)
2. RESTORE DATABASE TEST1 FROM BBA (Give the correct backup file / device
name) WITH NORECOVERY
3. Restore the subsequent transaction log files in order of backup WITH
NORECOVERY option till the final transaction log file
4. In the the final transaction log restore mention WITH RECOVERY and
STOPAT='date and time'
Thanks
Hari
"Mahendra" <Mahendra@.discussions.microsoft.com> wrote in message
news:CC884D41-EE2A-4557-8202-3219CAB42EA4@.microsoft.com...
> In SQL server 2000, one of co-work delete the row in a table. How can I
> recover the row.
> Thanks,