Re: Recover delete the row from a table?

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC884D41-EE2A-4557-8202-3219CAB42EA4@xxxxxxxxxxxxxxxx
In SQL server 2000, one of co-work delete the row in a table. How can I
recover the row.

Thanks,


.

Relevant Pages

  • Re: Restoring from non-truncated transaction log
    ... Hi - I suggest you read the Books Online topics on recovery models ... > NOT been backing up the transaction log, so I would assume the transaction ... > transaction log when you restore a database but not the transaction log? ...
    (microsoft.public.sqlserver.server)
  • Re: Full v. simple recovery mode
    ... As you saif if you backup the transaction log in frequent interval then you ... recommend you to go for FULL recovery model. ... FOr SQL 2000 for this database should not have ... db not being in single user recovery mode. ...
    (microsoft.public.sqlserver.setup)
  • Re: optimum log file size
    ... Fixing of Transaction log file based up on the amount of bulk transaction ... CUrrent log growth will be because of FULL recovery mode. ... If you do not require a point in time recovery or if your database ...
    (microsoft.public.sqlserver.clients)
  • Re: NTDS ISAM DataBase Corruption
    ... Did you tried the recover the corrupted Active Directory process that a gave ... This is brand new IBM Server. ... using symantec livestate recovery. ... Active Directory database is unavailable because it is damaged, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Log-size
    ... The user had an immediate problem: their transaction log filewere ... It is more valuable than the online database. ... periodic transaction log backups, I can recover that database from the FULL ... change the recovery model to support their ...
    (microsoft.public.sqlserver.server)