Tags: co-work, database, delete, irecover, microsoft, mysql, oracle, recover, row, server, sql, table

Recover delete the row from a table?

On Database » Microsoft SQL Server

1,855 words with 2 Comments; publish: Thu, 22 May 2008 14:09:00 GMT; (25031.25, « »)

In SQL server 2000, one of co-work delete the row in a table. How can I

recover the row.

Thanks,

All Comments

Leave a comment...

  • 2 Comments
    • 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.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:CC884D41-EE2A-4557-8202-3219CAB42EA4.sqlserver.todaysummary.com.microsoft.com...

      > In SQL server 2000, one of co-work delete the row in a table. How can I

      > recover the row.

      > Thanks,

      #1; Thu, 22 May 2008 14:10:00 GMT
    • 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.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:CC884D41-EE2A-4557-8202-3219CAB42EA4.sqlserver.todaysummary.com.microsoft.com...

      > In SQL server 2000, one of co-work delete the row in a table. How can I

      > recover the row.

      > Thanks,

      #2; Thu, 22 May 2008 14:11:00 GMT