RSS

[Video] ApexSQL Log – Software Review

08 Jan
[Video] ApexSQL Log – Software Review

Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery.

The team at ApexSQL were very friendly and offered me lots of support and help in using the product.  I opted to do everything myself just to see how easy it is to learn and use the product.  It took me about 30 minutes to get fully acquainted with it; although I’m not an expert now I know my way around the product very well. It’s always great to have a product with an easy to use interface that does not have a steep learning curve.

Note: this is not a product endorsement

My over all impressions of the product is that is it very unique and could be extremely useful to people looking to see changes to tables via the transaction log (T-Log).  I cannot imagine doing this manually, it would seem to be very difficult to be honest. The product easily displays the DML and DDL commands issued on a particular database over a specific time period, or over the entire active T-Log as well as T-Log backups. At first, I thought that I could only see the logging information in the active T-Log, but after doing multiple T-Log backups and refreshing my session, I was able to cycle through the backups to see my transactions.  It’s quite an impressive tool!

There is one thing that was quite confusing and I go over it in detail in the video below. When you click on the “Create undo script” or “Create redo script” buttons on the top (ribbon?) tool bar it creates the script for EVERYTHING not just your selection.  Be very careful with this. You have to right click on the grid and select those options.  I’ve detailed this in the video if you’re interested in learning more about this.

Over all it is a good product, easy to use, easy to learn, and could be useful for people looking to audit transactions going on in their system and potentially recovering lost data.  I’ve put together a short demo of my test of the product I hope you enjoy and please check out http://www.ApexSQL.com for more information on their products.

The folks at ApexSQL were kind enough to provide for me a free license for their suite of tools in exchange for writing up a review about the product.  Just disclosing the reason behind this blog post 🙂

Here is the code used in the demo:
****You will have to create a Backup Device Called SQLBackups or use your own custom path****

Create Database ApexSQLLog
Go

Use ApexSQLLog
Go

Create Table ApexSQLTest
(
ID Int Identity (1,1),
FName varchar(50),
LName varchar(100)
)
GO

Insert Into ApexSQLTest (FName,LName) Values (‘Ayman’,’El-Ghazali’)
Go
Insert Into ApexSQLTest (FName,LName) Values (‘Ayman’,’El-Ghazali’)
GO
Insert Into ApexSQLTest (FName,LName) Values (‘Ayman’,’El-Ghazali’)
GO
Insert Into ApexSQLTest (FName,LName) Values (‘Ayman’,’El-Ghazali’)
GO
Insert Into ApexSQLTest (FName,LName) Values (‘Ayman’,’El-Ghazali’)
GO

Update ApexSQLTest
Set Fname = ‘FName2’,
LName = ‘LName2’
Where ID = 2
Go

Update ApexSQLTest
Set Fname = ‘FName3’,
LName = ‘LName3’
Where ID = 3
Go

Update ApexSQLTest
Set Fname = ‘FName4’,
LName = ‘LName4’
Where ID = 4
Go

Delete From ApexSQLTest
Where ID = 5
Go

Alter Table ApexSQLTest
Add MName Varchar(50)
Go

Backup Database ApexSQLLog
TO SQLBackups

—Repeat these two pieces of code
Insert Into ApexSQLTest (FName,LName) VALUES (‘TESTLOG’,’TESTLOG’)
Go 100

Backup Log ApexSQLLog
to SQLBackups

—–

SELECT *
From ApexSQLTest

USE master
Drop Database ApexSQLLog

Advertisements
 

Tags: , , , , , , ,

3 responses to “[Video] ApexSQL Log – Software Review

  1. david

    June 11, 2015 at 12:32 PM

    how about generating undo script for repairing Update accident on > 1 million rows?

    can this software do the job? i dont want to buy this software if it can’t.

    Thanks

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: