SQL Server Performance

Using log file

Discussion in 'SQL Server 2005 General Developer Questions' started by ashish.johri2007, Feb 27, 2007.

  1. ashish.johri2007 New Member

    This is probably first time when my colleague deleted around 1000 records because of on bad query[:0]. I want to use log file to get them back or to recognize where he went wrong. Can anybody help me seeing the log file[V]?

    Regards,
    Ashish

    Ashish Johri
  2. thomas New Member

    you need 3rd party software to do that.
  3. ashish.johri2007 New Member

    Thanks Thomas. Can I load any tool from net for free this time.

    Ashish

    Ashish Johri
  4. thomas New Member

    I don't think any are free, but you might be able to get an evaluation copy. Lumigent is one provider.
  5. satya Moderator

    YOu cannot use the evaluation copy for the user databases, you have to purchase in order to recover the data.
    Look at the software spotlight section in this website for more information on such tools, I feel Lumigen't is expensive (quality though) as compared to others.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. MohammedU New Member

    You can't generate roll back scripts using trial version....
    So if you have full backup and tlog backup then restore it as different db and copy the deleted data...



    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page