Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Review: Recover from Almost Anything with Log Explorer 3.0

By Brian Knight,

Every DBA has received the call before

 

 

Every DBA has received the call before. It’s 4:50 PM on a Friday and you’re getting ready to go home and enjoy your weekend. All of a sudden your phone rings. You know you shouldn’t answer and you should turn the other way. Probably due to a lack of oxygen in your cube habitat, you decide to answer the phone.


”Uhhh Brian, I made a terrible mistake,” mutters the developer. Luckily you have your trusty Tums bottle nearby and you decide that preventative action is needed before the developer continues. You pop a few Tums and grunt at him to continue.

 

“The last upgrade we ran at 2pm in production wiped out all the accounting records because I forgot my WHERE clause,” the developer moans. You quickly realize that you’ve been eating the Tums tablets like popcorn as the developer speaks in slow motion. You do this because he didn’t call you 3 hours ago when he first did this. You know that your system receives 5,000 transactions an hour and 3 hours of data loss is impossible to explain to management if you do have to restore from you last transaction log at 3:15 PM.

 

You stare up at the florescent lights and realize that your backup/recovery plan has a hole. A huge hole that this developer just found with such ease. It’s going to be a long night.

 

Luckily, Lumigent Log Explorer has improved on an already brilliant product to help combat these types of scenarios. Log Explorer 3.0 came out last month to improve on their already strong monopoly in looking at the SQL Server transaction log to find rogue transactions and remove them among other things. The product has the following functions (although not limited to these):

 

  • Viewing the transaction log (only product on the market that can do that)
  • Viewing transactions in a backup file
  • Viewing transactions in real-time
  • Seeing who did what transaction when and rolling back that transaction
  • See database statistics like how many inserts, updates and deletes occurred on the server
  • Look at the history of a record and how it changes over time
  • Auditing schema and security changes
  • Recover transactions or even a dropped table

 

The most important item to mention here is that this is all done without triggers or performance hit to the SQL Server. I did see a slight performance hit for viewing transactions in real-time, but no more than one would see if you were monitoring Profiler. I did not see any performance hit when looking at the transaction log items that had already occurred. With auditing products that do use triggers, I have seen larger (although reasonable) performance hits. Because Log Explorer 3.0 uses the transaction log, it provides a gold mine of information about who did what when.

 

The install of the product went without a hitch. I reviewed the Log Explorer 3.0 Enterprise Edition, which has some added investigative features, which I will discuss. The install has a client component and a server component. The server component installed extended stored procedures used to peer into the transaction log and the client itself looks almost like 2.0 of Log Explorer. I did encounter typical domain problems when trying to run the program to install the server component on a SQL Server that was on a remote domain. This was fixed by loading it locally on those servers.

 

After that, I ran through the tutorial, which was one of the most interactive tutorials I’ve ever seen to walk you through the program. This tutorial made opening the program for the first time and actually using all of its features a snap. Whatever money Lumigent spent on this was well worth it in this reviewer’s eyes and is well worth the 10 minutes for a new user.

 

Once you open the application, you connect to the database logs and then you’re ready to roll. Figure 1 shows you what the application looks like. One of the nicest features that would solve the developers problem where he forgot a WHERE clause would be the Undo Transaction option. The option produces a SQL script to run against the server to undo the transaction.

 

Lumigent Log Explorer 3.0 can also recover lost tables, whether they were dropped or truncated. This feature will generate a script that is necessary to create the table and all of its data (as insert scripts). You may have to temporarily disable foreign key constraints as you’re inserting data if you receive table constraint errors.

 

In this reviewer’s opinion, Lumigent has done it again with their newest release of Log Explorer 3.0. The ability to restore data that is truncated and dropped tables was a gold mine and will save DBAs tons of time and headaches. In this time of tight budgets, if I had to have one tool in my DBA toolbox, Log Explorer 3.0 would be it. Beware Enron, because Log Explorer can find and recover your data even if you’ve deleted it and the backups!

 

Review in a Nutshell

 

 

Rating

Return on Investment

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - A steal when you compare the price of downtime

Ease-of-Use

 

 

 

 

 

 

 

 

 

 

 

 

4.5 - I wish the drop-down boxes were better organized but very easy-to-use application.

Features

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - They’re the only tool on the market that can view the transaction log

Learning Curve

 

 

 

 

 

 

 

 

 

 

 

 

4.5 - The interactive tutorial made learning this product a 10 minute process

Documentation/Tutorial

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - Hands on tutorial and documentation were excellent.

Time savings

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - Saves tons of time in auditing and rolling back single transactions

Lack of Bugs

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - None found during this review

Support

 

 

 

 

 

 

 

 

 

 

 

 

5.0 - Support provided phone number to call back in less than 10 mins when anonymously e-mailed

Overall

 

 

 

 

 

 

 

 

 

 

 

 

5.0 – Lumigent has done it again!

Specifics

Vendor Information

IT-Map International
Phone:
(866) LUMIGENT
Address: 289 Great Road Acton, MA 01720 USA
E-mail : info@lumigent.com 
Website : http://www.lumigent.com

Pricing

Log Explorer Enterprise Edition
Price : $995 / Server

Log Explorer Professional Edition
Price: $395 / Server

30 day full demos are available of all Lumigent Products

 

Total article views: 3975 | Views in the last 30 days: 2
 
Related Articles
ARTICLE

Review of Lumigent Log Explorer v4

Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our ...

ARTICLE

Product Review: Log Explorer 2.0

Anyone that has ever forgotten a WHERE clause in an UPDATE or DELETE syntax still has the bruises. L...

ARTICLE

Review: Log Explorer 2.1

Lumigent has updated their transaction log analysis tool to include a number of features that every ...

ARTICLE

A Look at Log Explorer

Have you ever wanted to read your transaction log? Wonder what information is inside there? New auth...

FORUM

Review of Lumigent Log Explorer v3

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/column...

Tags
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones