Review: Recover from Almost Anything with Log Explorer 3.0

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Review: Recover from Almost Anything with Log...

Review: Recover from Almost Anything with Log Explorer 3.0

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Friday, July 19, 2002 12:00 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/lumigentlogexplorer3.asp

Brian Knight
Free SQL Server Training Webinars

Post #5590

RonKyle

Posted Monday, July 22, 2002 1:49 PM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 9:32 AM
Points: 671, Visits: 1,509

I agree this is a great tool. We ran a lot of tests and simulated several disasters, all of which we recovered from. The interface is not entirely intuitive. For example, the only way I found to rollback a single transaction was to right click on the transaction.

Brian points out that foreign keys might have to be dropped when restoring information. To that I would add that you might need to disable triggers to properly restore the data. Small potatoes considering the value of the recovery but should be kept in mind anyway.

Post #37996

David Benoit

Posted Tuesday, July 23, 2002 6:54 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

Couldn't agree with Brian more. This is a great product! Great review!

David

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #37997

Brian Knight

Posted Tuesday, July 23, 2002 7:00 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Thanks for the comments Ron. I too tried to "break" the program as best I could and couldn't do it

. It seemed that in most cases of a breakage it was a user problem like loading orphaned records in. I tend to agree that the interface needed some work in the area you mentioned but I wonder if it's more of a technical reason versus an interface reason why that couldn't do that.

Brian Knight
bknight@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars

Post #37998

Brian Lockwood

Posted Wednesday, November 05, 2003 9:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 04, 2007 10:09 AM
Points: 198, Visits: 2

Brian,

Generally good review - but this point is no longer true as of 10/2003

"Viewing the transaction log (only product on the market that can do that) "

There is another product on the market that can do this LockwoodTech Log Navigator - http://www.lockwoodtech.com/index_lognavigator.htm

Log Navigator currently supports data change audits only but support for DDL and Select auditing is planned soon.

Brian Lockwood
LockwoodTech Software - value added SQL tools
http://www.lockwoodtech.com

Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed

Post #37999

« Prev Topic | Next Topic »

Permissions