Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Review: Recover from Almost Anything with Log Explorer 3.0 Expand / Collapse
Author
Message
Posted Friday, July 19, 2002 12:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Posted Monday, July 22, 2002 1:49 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:54 PM
Points: 820, Visits: 2,135
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
Posted Tuesday, July 23, 2002 6:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:02 AM
Points: 2,049, Visits: 3,596
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
Posted Tuesday, July 23, 2002 7:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Posted Wednesday, November 5, 2003 9:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 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 »

Add to briefcase

Permissions Expand / Collapse