dcsimg
Results 1 to 5 of 5

Thread: Recover Deleted Records

  1. #1
    Join Date
    Mar 2005
    Location
    Philippines
    Posts
    2

    Question Recover Deleted Records

    I want to know what to do to recover the deleted records on a specific table. Unfortunately, the dba was unable to activate Trace feature and I am not familiar in using the transaction logs to retrieve data.

    please help.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can restore db from good backup if have any. Or need third party tool, like Lumigent's Log Explorer.

  3. #3
    Join Date
    Mar 2005
    Location
    Philippines
    Posts
    2

    Deleted Records

    The dba told me that there is a scheduled backup of db logs every 2 hrs and I should check each log one by one to find the exact time where the data was being deleted. Could you give me an idea as to where to find freeware or 3rd party tool for this?

    BTW, Lumingent is not available on our country

    Thanks a lot!

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    download diagnostic manager from www.idera.com. it has the feature of looking into log files on the current database.

    You can use this even on trial period.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Hey apogoreliy, please don't keep digging out old threads.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •