Introduction to ApexSQL Log

Audit, revert or replay SQL Server database changes including the ones that have occurred before the product was installed. Restore damaged or missing data and objects. Capture information on the user, application and host used to make each change. Schedule auditing unattended and review the automatically generated comprehensive auditing reports. Get your 14-day free trial at http://www.apexsql.com/Download.aspx?

---

Closed Caption:

welcome to this introduction to apex
equal log apex equal log is a sequel
server transaction log reader which not
only allows you to view data and your
transaction logs in a format you can
understand but also rollback changes
recover data and determine who made
those changes in this video I will show
you how to view the data in your log for
a specified period find out who
performed a certain action on the
database identify all the operations
which form part of the same transaction
and roll back any unwanted changes this
script add some rose into the production
. unit measure table then updates the
production . product table and then
deletes the Rose it added now let's look
at this data and apex equal log
first you'll connect to the database we
will select adventureworks
we will only use the online transaction
log we only want to view changes made in
the last couple of minutes so we will
select custom and specified today's date
and then we can type the time in here
apex equal log also offers other filter
capabilities like operations and tables
but for the purpose of this
demonstration we will just focus on date
and time you can view the results in
three different ways open results in
grid this option displays the results in
a grid and allows additional filtering
advanced transaction selection and
operation export results to file this
option exports the results to a
specified file format create undo and
redo script the supported file formats
are HTML XML sequel csv and sequel book
files create batch file this option
creates a batch file for process
automation you will be able to choose
your output type path scripting options
and export results into a specified file
type including HTML XML sequel csv and
sequel book we will use open results in
grid
as you can see here we have the inserts
here we have the update and here we have
the deletes
if you click on any of these operations
you can see the operation details the
row history the undue script the redo
script
and the transaction information such as
when it occurred and who did it
the grid filter on the left-hand side
allows you to filter the grid on the
right-hand side so if you select a date
range here it will be a subset of a date
range previously selected if you want to
export a row you can check it right
click on it and export it as an XML csv
HTML sequel script or sequel book file
now let's have a look at transactions
first we will run another scripture on a
transaction it begins a transaction that
I perform some tasks which should be
done as a unit and then commit the
transaction
if the schema an object name is shown as
unknown it means the object has been
dropped and the object name is no longer
available if you don't want to see
dropped operations you can go to data
operations and uncheck the show
operations on drop table checkbox
we have created a transaction that
performed for operations the nice thing
of apex equal log is you can see which
operation from part of a transaction by
right-clicking on it and selecting the
Select transaction option from the
context menu which will then select all
of the operations that occurred within
that transaction and then you can create
an undo or redo script for the entire
transaction
these are just a few of the useful
features of apex equal log please
download our free trial to try it out
for yourself
thank you for watching this video