ApexSQL Log - Software Review

Ayman El-Ghazali
www.TheSQLPro.com
@TheSQLPro
Demonstration using ApexSQL Log software which is a tool used for SQL Server Transaction Log discovery and recovery.

Note: this is not a product endorsement

Original Blog post for video: http://wp.me/p11bPi-oO

---

Closed Caption:

hello there everybody this a middle is
I'll
from the sequel pro dot com tainted a.m.
here to talk to you about
a product by a pic sequel called a pic
sequel log
and as full disclosure
I do not work for a Pepsi cool rather
they provided me
very generously with this product test
blog about so era today
to to go through this product
I love in a few minutes here
show you how to use
so far so wrong and create a sample
database and all this code I'm using
here for testing
available at the original blog post
and should be in the description of this
video
gonna answer you know to some basic data
here
on a couple updates
delete
also
halter command
pat
an extra call for middle name this their
simple tower
have already loaded the program
going out
statement
to select mine database
to me database I'll have to for shit
here's apex along
club mix ext I have a selections for
authentication
I V when does a sequel I can also do
this
on a different server aside to
and I'll click Next and will find my log
file
and just just to be up
you know
free from my scripts product a pad save
a lot actually looks to the transaction
log files and through
transaction log backups as well
case you need to look for something
so I can select on on this for screening
today time range
I'm going to take the entire transaction
log
can open up advance
options and i cant pick specific
operations that I wanna see
I've cited to see all almighty DL
commands
when you first load the software all
these will be unchecked
there's a way to default for everything
checked I'll show you
up inside operations us are not the
person South options
program
I can also picked specific tables that I
wanna see
filter out by specific schemas not sure
what I would do
system tables but
no
there something to explore
for the customer transactions
did set what type of transactions I
wanna see
as well as the users that I wanna filter
by
let's and I don't wanna see any changes
made by guest for example
their changes will be reflected
and then that there's a couple other for
advanced things up I'm not a current
style
0 click Next and a cat pee couple
options here but primarily done is to
use the results grid view
feel free to explore the software on
took me about
good 20-30 minutes kinda
play around with software get familiar
with it its
it's not
that complicated it's pretty
straightforward
to scrape for types of planets can see
here I have my pre
table
command and then followed by those in
search that I did
updates and want to leave handy
ALTER TABLE
and I could see here my answer
I can't see you note the values that I
inserted I can see
ID's identity so
each inserts gonna have a different
number
not get to the updates I can't see the
old value
and I can see the news on that I put it
just company
and then when I look at that lead I
can't see
you know ID the hike to the d4
call on the house are not on the road I
deleted
there's you know punch other information
in here for the history
there is a nice little slot here for
and on the script for a reduce script
let's say I i det this
on a staging server development now on
to redo it on production for example
I could get that here and then there's
some other
transaction information know what type
operation
stay the schema a object
which is the database name the time and
so on
and the stubs are available for all of
the different operations
each one obviously show something not
something different
so here I can to filter out if I wanted
to
more granular day time
I can also pic the DML operations are of
policy inserts
just check and click Apply and only
fresh this pain here for me
mostly people are concerned about update
and delete
I want transaction logs but not so
distant be
health
under DDL operations I have the option
filter out certain things
i interested in looking at
like I said I'm to users here
let's say for example I use a sequel
2012 administrator
I don't wanna see anything
that they've done like for example on
narrow down a specific user
that house in making unauthorized
changes for rent
so i cant just feel trapped by that news
it's actually quite
you know quite powerful
quite useful
to at this here
I just wanted to make a note that now a
you can't see the operations but can
also
script that now like let's say I wasn't
happy with these two updates for example
what I would do is i would select them
and that I would likely
and I would create and undue script
and here's the script so I have two
options
option copy the South impotency hormone
sudo or have the option executing here
which is great wanting to know
is that if I have these two selected
and I click Create undue script it's
going to create a nondescript for
everything
not just
the two that I selected which is I guess
can't really call it a bug but it can be
a little bit confused
so create a reading scripts been created
for the entire database
and everything in that that
in that transaction of not just the ones
I select so it's just something
to to be aware so back to my
Management Studio here
I'm going to take it back up at this
database
on going to
insert
under grows I'm gonna do a log backup
Scott verified that
no 104 rose
gonna do another two inserts and do
a log backup
each you
300 for records right
so to go back to mine database here
gonna click me fresh
I might if its new back to a pic
psicología going to click Refresh
gonna see 300
rose here
so what I want to do this I actually
want to
cert
couple more rows
couple for backups I'm just backing up
to a
backup device that I've created here on
my server
those all
what I'm trying to do here
isn't trying to
get the transaction log to read use sum
up the truncated space
space and truncating after doing
a transaction log backups so let me
to acquit or tear at 904 rose
but when I refreshed only have 360 run
right here can see it
or rwanda's 360
so you might be wondering where the
other you know 600 or 500 something rose
went and that kinda confusing at the
beginning
but Tom it it's easy to fight this is
these are the the the current the
transactions in the current
transaction log so senso broke
data that data was you know transactions
for was raining transaction log
and want to get a backup that portion of
the law was
you know marked as available for reuse
and once I inserted enough data that
portion that was marked for reuse was
actually overran with
transactions so you might be wondering
well
this is to only work over the
active transaction long um and that's
kinda what I was thinking I should I
started blogging about
but cool thing is I go back to session
settings here
i click Next
come on
maxed
see tripod
up
sec
sorry bout that had a problem I with my
session so
I will create new session
and now that I have a new session I can
actually select
my transaction log backups that's kinda
cool house
you know us
nice meditating hear about time in and
name transaction log in you know what
type it back but this this is it
database for backup tight did
draw transaction log backups so I click
Next
and I'm gonna keep the same options
and as see I have
all of the transactions now
that I've done including the ones in the
transaction log backups
just great
so have a lot more that
to what I had looking at before so you
know a little bit
tricky you cannot trading session
go from there not sure what my updates
want
tenets clear
why that is
so the other thing on at the show was
assessed our
where my updates
on my updates
session
so
its
I know what prices for backup
trials
it
stapled
its why
way to a lot backup which or
that
lot o'clock
try to make sure that
%uh by another process
ok
things by this process
while
interesting
close this out
that
okay good
not to do a lot better that's kind of
interesting
as you learn
these demos couple
its gonna try to do
opened the session up just make sure
that
I can't find those updates
slipped the ring
such long
school
all
those last three updates that I did
that I was able to backup think that
great so the lesson on it shows under
options here
just quickly you can
you know
softer color scheme
so on
it's like how your great looks
how the script editor looks ronnie's
apex equal building on
gonna go straight to you sickle
Management Studio so-and-so
or
you can filter out here these are coming
here default filters
as he saw under operations eyesight that
everything
seeking to change a couple things here
it
this company
that same predictive tool
you know I've I've never use it on E
production system
but it looks
you know pretty good then and has some
good export options think
export things and 21 I select the script
I can
export checked as a
tickle script
send it someone to do something or put
on a different server or
prepared on the job or something like
that so it's pretty
me
never really tried to copy roast
clipboard state that shot
looks like
on
us
says thank you note top
the pros
somehow to
you know like tickling support
get it nope
yeah
well not really sure what that us but
no
I'm not an expert in follows the
functions at this
tossed her but it did it's pretty good
it's got some some cool stuff
you know it looks very nice and has this
great app for resources so
go to their support side get updates and
bunch other stuff you need to write
at a softer so I highly recommend it
you grab a demo this tried out
teacher works for your environment you
know
happy transaction of fish thank you for
watching
and have today