Post reply

Reading log fiile

  • February 25, 2012 at 7:20 am

    #265226

    hello every body

    i have some tables in sql2008 which has some field.one of the field has been deleted from a record.i do not know who delete and when deleted?

    how can i find the user which delete it???

  • February 25, 2012 at 7:34 am

    #1451693

    Unless you had something in place at the time the data was deleted (trigger, SQLAudit, etc), there's not much chance you will be able to find this out.

    While SQL does log changes in the transaction log, the log is not intended to be human-readable and it does not keep track of login names, host names or application names, all things that you need to identify who and what deleted the data.

    If you want to try the tran log, log reader tools for SQL 2008 start around $1000.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 1, 2012 at 4:29 am

    #1453542

    Hey buddy

    u cant find now the user. but for future create sql audit specification for that server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply