Transaction log examination for Field data deletion

Posted on 2005-04-27
Last Modified: 2010-03-19
I have a Database with a table and some fields in it.  One of the records had some data deleted from a field and I want to examine this.  Mainly get date and time when it happened exactly.  I have restored the database in a temporary location from last night and the data exist.  So I know that the deletion command exist in my current logs.

The table is and the field is Custom_Field1.  The specific Record is where EVENT_NUM=74703

How do I first “examine” the Transaction logs?  Should I restore them to my test database first?  I just need to find the command that was issued that deleted this field for that record.

Can I open these in Notepad and search for this info?
Question by:lawson2305
    1 Comment
    LVL 34

    Accepted Solution

    You can't really examine them on your own.  Third party tool is currently required like logexplorer (

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now