Searching the Transaction Log

RadderzRadderz Posts: 2 New member
in SQL Backup
Do any of your products enable you to view and analyse the transaction logs?

We would like to be able to analyse the log files by seaching for columns and values; ie Updates queries where value tblSite.SiteId == 12

Is this at all posible? Currently we use software from a different provider to do this task, but would like to move to red-gate (as we have other bundles and would like some alternatives)

Thanks, Radderz
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi Radderz,

    Redgate no longer has a product that views and analyses transaction logs.

    In the past, Redgate had a product called SQL Log Rescue which would analyse SQL 2000 transaction logs, to help recover from an accidental deletion of objects and data. This product was removed from sale some years and is no longer supported.  

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • RadderzRadderz Posts: 2 New member
    Ok thanks Eddie,

    It's a shame, we have only found one provider which offers both the reading and searching of transaction logs. It's a great tool and used to use it regularly before being forced to upgrade with the latest SQL server version, but of course a lack of competition means that they can charge what they like.

    If you offer in future please let me know.

    Thanks, Radz
    · Share on Twitter
  • mukultiwari0101mukultiwari0101 Posts: 1 New member
    Searching for the one-stop solution to read and repair SQL transaction Log files then, you should definitely try SQL Server Transaction Log Reader Software for free. SQL Server Transaction Log Reader is one of the top reviewed log reader and database file recovery tools. It can repair the corrupted transaction log file. 
    · Share on Twitter
Sign In or Register to comment.