Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: How to read log Files

    Some records got deleted from our DB. We don't have any triggers to log this delete transaction. Is there anyway to find out from log files or someother places to find out about this deletion. Is this information stored in transaction log. We do complete backup every night. So I think the transaction log will be truncated after the complete backup right?
    Please advise on this.


  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    If recovery mode is Full then Lumigent Log Explorer (FULL VERSION) can be installed and the specific transaction can be identified. If recovery mode is Simple, Log Explorer can still be used, but chances of recovering the transaction are much-much slimmer.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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