Post reply

DMV to show wiped table

  • September 18, 2008 at 9:33 am

    #93824

    Hi,

    we've just had a table wiped from one of our reporting tables and wondered if there is any DMV (or other method that can be used) to show recent deletes from tables.

    We can restore the data without any problem but this is a question more about traceability (without audit tables!) that restoring data.

    Any advice welcome 🙂

    Eamon

  • September 18, 2008 at 9:48 am

    #873717

    No DMV. You may be able to use a 3rd party log reader and read the info from the tran log, but that's not an ideal situation as the transaction log isn't there as an audit solution.

    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

  • September 18, 2008 at 9:51 am

    #873722

    Thanks alot Gail,

    just as I thought !

    Thanks,

    Eamon:cool:

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

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