www.apexsql.com Open in urlscan Pro
2600:9000:2251:8e00:4:2986:df00:93a1  Public Scan

Form analysis
0 forms found in the DOM

Text Content

For the best web experience, please use IE11+, Chrome, Firefox, or Safari
 * Resources
 * Blogs
 * 
   
 * 
   
 *  * Account Settings
    * Sign Out
    * Sign In
    * Create Account
   
   

Solutions
Main Menu

 * APEXSQL OPERATIONS TOOLKIT FOR SQL SERVER
   
   The essential SQL DBA tools for managing SQL Server production environment
   
   Learn More

 * APEXSQL COMPARE AND SYNC TOOLKIT FOR SQL SERVER
   
   Compare and sync SQL schemas, code, files, folders and data
   
   Learn More

 * APEXSQL DEVOPS TOOLKIT FOR SQL SERVER
   
   SQL DevOps tools required to drive an automated DevOps workflow
   
   Learn More

 * APEXSQL FUNDAMENTALS TOOLKIT FOR MYSQL
   
   Fundamental tools for simplifying and automating routine MySQL tasks
   
   Learn More

 * APEXSQL FUNDAMENTALS TOOLKIT FOR SQL SERVER
   
   Fundamental tools for simplifying and automating routine SQL Server tasks
   
   Learn More

 * APEXSQL SECURITY AND COMPLIANCE TOOLKIT FOR SQL SERVER
   
   Classify, discover, check for vulnerabilities and protect personal and
   sensitive data across your SQL Server databases and throughout your DevOps
   CI/CD lifecycle.
   
   Learn More


Support
Main Menu
 * Support Portal
 * Contact Support


Partners
Main Menu
 * Partner Program
 * Partner Portal Login


About
Main Menu
 * Why Quest
 * Leadership
 * News
 * Careers
 * Contact Us


Resources
Blogs
Free Trials Request Pricing

Home / SQL transaction log reader



SQL TRANSACTION LOG READER


ApexSQL Log is a SQL Server database transaction log reader which allows users
insight into SQL Server database transaction log files and backup. ApexSQL Log
can be used both locally or remotely to perform auditing and recovery jobs.
Users can audit database changes and present in a comprehensive grid, where they
can be analyzed and inspected in great detail, including who made the change and
when, as well as the before-after change values and full history of affected
rows regardless of the auditing method (local or remote).
03:35

Download Free Trial


OVERVIEW


APEXSQL LOG

 * Overview
 * Benefits
 * Resources
 * Why ApexSQL Log?
 * Related Topics

 * Download Free Trial


BENEFITS

 * AUDIT DATA, SCHEMA, AND PERMISSION CHANGES

 * GAIN FULL VISIBILITY INTO YOUR TRANSACTION LOGS

   

 * ROLLBACK OR REPLAY ANY DATABASE TRANSACTION

 * FORENSICALLY INVESTIGATE WHO CHANGED WHAT AND WHEN

   

 * IMPLEMENT BEFORE AND AFTER AUDITING

 * VIEW A COMPLETE HISTORY OF ROW CHANGES

   

 * REVERSE INADVERTENT OR MALICIOUS DATABASE TRANSACTIONS

 * AVOID PERFORMANCE OVERHEAD AND DATA STORAGE

   


FEATURES

TRANSACTION VISUALIZATION

View, group, and sort transactions in a custom high performance grid with
advanced filtering options. Learn more


DATA RECOVERY

View deleted and damaged data. Reverse inadvertent or malicious database
transactions to repair data. Recover from specific data loss/damage without
relying on full database restores. Learn more


BEFORE AND AFTER AUDITING

View before and after values for update operations, who changed what and when
the change occurred as well as the full row history of row changes. Learn more


UNDO OR REDO

Selectively view or script one or all operations in a transaction and create
replay or reroll scripts. Learn more



TRANSACTION ISOLATION

Isolate specific SQL Server transactions by user, date, object, change type, and
more. Utilize advanced grid search algorithms including regular expressions,
transaction details and row history search. Learn more


MULTIPLE REPORT AND OUTPUT FORMATS

Display the transaction log information in grid or export to HTML, CSV, XML, SQL
Script, SQL Bulk files or directly to a database. Learn more



DETAILED LOGIN INFO

Find out the name of the login, who and when made the change, even before the
product was installed as well as granular details for every operation and
transaction recorded in the transaction log. Learn more


UNATTENDED EXECUTION

Read transaction log files unattended during off peak hours via the CLI,
minimizing the overhead on your server. Learn more



VISUAL THEMES

Customize the visual appearance with interface themes. Learn more



RESOURCES AND SUPPORT

CONTENT



FAQS



GETTING STARTED



KNOWLEDGEBASE



NEWS



RELEASE NOTES



REQUIREMENTS



SOLUTIONS



TROUBLESHOOTING



VIDEOS




WHY APEXSQL LOG?

FORENSIC AUDITING

Find out who changed what and when. Review values before and after a change as
well as the complete history of row changes, from initial insert to all
subsequent updates or deletion. Learn more

DISASTER RECOVERY

Find out who changed what and when. Review values before and after a change as
well as the complete history of row changes, from initial insert to all
subsequent updates or deletion. Learn more


LOAD TESTING

Easily record loads on production and then replay them on staging, simulating a
production environment. Learn more

ZERO DATA LOSS RESTORES

When restoring from the most recent backup, any data added since the backup date
will be lost. ApexSQL Log can capture those "missing" transactions and easily
replicate them to your restored database, ensuring you never lose a single row
of data from an emergency restore.


ROW-LEVEL RECOVERY

Restore lost or damaged data, down to the row level, directly from a backup, or
even the online log, without having to restore the entire database. Learn more

POINT IN TIME RECOVERY

Roll back an entire database or only specific database tables to the exact point
in time. Learn more


DDL AUDITING

Track any DDL changes and roll back any unintended structure changes on SQL
Server database tables. Learn more

NO DOWNTIME/DATA LOSS MIGRATIONS

Ensure that no transactions are missing after migration downtime by replaying
the transactions which have occurred during the downtime period by replaying
them on the migrated database by reading the transaction log file. Learn more


BEFORE-AFTER AUDITING

Drill down and see the values before and after the change has occurred on the
row level. Learn more

SQL INJECTION ATTACKS

Immediately identify SQL injection attacks, isolate affected/damaged data and
reverse/repair the damage. Learn more

Learn more


GALLERY


MAIN TRANSACTION GRID


LOG AUDITING WIZARD


OUTPUT OPTIONS AND FILTERS


COLUMN SELECTION


OPERATION DETAILS

 * 
 * 
 * 
 * 
 * 

MAIN TRANSACTION GRID



LOG AUDITING WIZARD



OUTPUT OPTIONS AND FILTERS



COLUMN SELECTION



OPERATION DETAILS

 * 
 * 
 * 
 * 
 * 


RELATED TOPICS

APEXSQL LOG 2018 – SCREEN SHOT TOUR

This article represents a screen shot tour of ApexSQL Log features with a brief
description

APEXSQL LOG GENERAL OVERVIEW

This video explains how to 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 and more

APEXSQL LOG VS. SQL SERVER CHANGE DATA CAPTURE (CDC)

This article shows side by side comparisons of ApexSQL Log vs. SQL Server Change
Data Capture (CDC)

CONTINUOUS SQL SERVER DATABASE AUDITING AND REPORTING USING THE TRANSACTION LOG

This article shows how to setup ApexSQL Log to perform continuous nightly
auditing of SQL Server database transaction log files/backups and create
repository tables that will store all audited data by creating a repeatable
session in ApexSQL Log.

SQL SERVER TRANSACTION LOG READER USE CASES

This blog article covers the various scenarios when you might benefit from
reading the SQL Server transaction log with ApexSQL Log including auditing
changes on a database schema or data, troubleshooting security issues,
recovering data that was inadvertently updated or deleted, and more

SQL SERVER DATABASE RECOVERY FLOW CHART

This article is intended to help users choose the best recovery solution for
their particular disaster recovery scenario. The tools which offer solution are
ApexSQL Log and ApexSQL Recover

ADVANTAGES OF APEXSQL LOG

This blog article describes key features, as well as important advantages of
ApexSQL Log

HOW TO CHOOSE AND PERFORM THE MOST APPROPRIATE RECOVERY SOLUTION AFTER THE DATA
LOSS

This knowledgebase article shows how to ensure that recovery chance is
maximized, by taking the correct post-incident steps, understanding the recovery
process, and making the right choice between ApexSQL Log and ApexSQL Recover
when planning the recovery

SQL DISASTER RECOVERY ARTICLE INDEX

This article provides key information and links to all important
recovery-related articles


TESTIMONIALS

KRAFTWERK INFORMATIONSTECHNOLOGIE GMBH

Thank you! You are just great! May I recommend your company and products
wherever and whenever you want me to do? ... When we would start using ApexSQL
Log I'll purchase it for sure, your service is exceptional!

Georg Untersalmberger Managing Director

MICROSOFT BI ARCHITECT

I had downloaded the ApexSQL Log tool for a very specific need that I had to
quickly find some information from a transaction log backup – and it worked
GREAT!

Dave Fackler Microsoft BI Architect

ADVANCED DATABASE DESIGNS LLC

Thank you, thank you, thank you!!!!! What I could not accomplish over the past 7
days ApexSQL Log did in 20 minutes. The anguish of data loss is now over. You
folks are brilliant!

Steve Sweeney Advanced Database Designs LLC

18TECHS

I just wanted to tell you how much I appreciated your truly exceptional
service... At first glance, it seemed like the ApexSQL Log would not be able to
find all the deleted records (beyond the 10% recovery permitted by the trial
version). Thanks to your willingness to help and your lightning fast support
team, it appears that my team was able to find and recover all the missing
data…you and your team’s extraordinary service was that spoonful of sugar
needed, thank you

Jalil Fanaian Director

FEDERAL EMERGENCY MANAGEMENT AGENCY

Brian, thank you very much for your help with getting us this product today. I
have been using the ApexSQL Log + ApexSQL Recover trials for the past few days
and they are outstanding. I just used the ApexSQL Recover tool to recover about
some data that would have taken numerous work hours to re-enter, so thanks again

Christopher R. Wujciak IT Database & Websites Manager

MEDIWARE INFORMATION SYSTEMS

I'm the developer/dba responsible for pimping your products to my company. After
drooling over them for years I finally found an employer who recognizes their
worth enough to purchase the entire suite. The purchase was prompted by a recent
life-saving by your ApexSQL Log software (I'd installed the trial). I looked
like a hero and when questioned about how I'd saved the day, I told my project
manager about your software suite and an RPO was submitted for approval that day

Megan Willesen Senior Applications Developer

PAR GOVERNMENT SYSTEMS CORP.

Let me start by thanking you once again for such a wonderful suite of tools.
ApexSQL Log has saved my life more than once in the past

Eric Pfirman Geospatial Information Specialist

BLACK STUMP CONSULTING GROUP PERTH, WESTERN AUSTRALIA

P.S. From what I've seen so far with the program, I can honestly say it's a
great tool and the layout of the user interface is excellent. Often I find I
won't use a program if the interface is either confusing, cluttered or just
plain ugly, even if it's the best exponent of what it's designed to do. No such
problems with the [ApexSQL Log]! :)

M. Holman Computer Programmer

STATLINE

Best. Software. Ever. It's a long story, but ApexSQL Log may solve a previously
un-solvable issue for us.

Seth Buxton DBA

HARMONY PRINTING

We had an update query which affected 110,000 rows in our SQL Database. With
ApexSQL Log, this amazing software allowed me to create an Undo Script. Thank
you ApexSQL for your prompt response and resolution to my critical issue I
faced. What a pleasure to deal with!

Junaid Ali Digital Solutions Specialist

DIRECTOR OF IT PREFERRED PRIMARY CARE PHYSICIANS

I mainly use ApexSQL Log. We do 5 minute transaction log backups and I have had
a number of cases in which I had to prove/verify a specific person modified a
row. Our application does not log information to the level needed for that
verification in all cases. Your tool allowed me to quickly identify the
necessary rows and provide documentation to the requestor.

Ted Davidson Director of IT Preferred Primary Care Physicians

E.ON ELNAT SVERIGE AB

ApexSQL Log worked beautifully and I was able to test and restore deleted SQL
data.

Patrik Hildingsson E.ON Elnat Sverige AB
Previous
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 

Next


GET STARTED NOW

Read the SQL Server transaction logs to audit, rollback or replay database
schema and data changes.
Download Free Trial


ABOUT

 * About Us
 * Leadership
 * News
 * Careers
 * Subscribe to ApexSQL

SUPPORT

 * Support Portal
 * Contact Support
 * Renewals and Upgrades
 * Resend Keys

CONTACT

 * Contact Quest
 * Request Pricing
 * Licensing
 * Accounting


© 2023 Quest Software ALL RIGHTS RESERVED. Legal| Terms of Use| Privacy Policy
Cookie Preference Center| Cookie Use Policy
 * 
 * 
 * 

Please wait...


This is the end

By clicking “Accept All Cookies”, you agree to the storing of cookies on your
device to enhance site navigation, analyze site usage, and assist in our
marketing efforts. Cookie Use Policy

Cookies Settings Accept All Cookies



COOKIE PREFERENCE CENTER

When you visit any website, it may store or retrieve information on your
browser, mostly in the form of cookies. This information might be about you,
your preferences or your device and is mostly used to make the site work as you
expect it to. The information does not usually directly identify you, but it can
give you a more personalized web experience. Because we respect your right to
privacy, you can choose not to allow some types of cookies. Click on the
different category headings to find out more and change our default settings.
However, blocking some types of cookies may impact your experience of the site
and the services we are able to offer.
Cookie Use Policy
Allow All


MANAGE COOKIE PREFERENCES

STRICTLY NECESSARY COOKIES

Always Active

These cookies are necessary for the website to function and cannot be switched
off in our systems. They are usually only set in response to actions made by you
which amount to a request for services, such as setting your privacy
preferences, logging in or filling in forms. You can set your browser to block
or alert you about these cookies, but some parts of the site will not then work.
These cookies do not store any personally identifiable information.

PERFORMANCE COOKIES

Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and
improve the performance of our site. They help us to know which pages are the
most and least popular and see how visitors move around the site. All
information these cookies collect is aggregated and therefore anonymous. If you
do not allow these cookies we will not know when you have visited our site, and
will not be able to monitor its performance.

FUNCTIONAL COOKIES

Functional Cookies

These cookies enable the website to provide enhanced functionality and
personalisation. They may be set by us or by third party providers whose
services we have added to our pages. If you do not allow these cookies then some
or all of these services may not function properly.

MARKETING COOKIES

Marketing Cookies

These cookies may be set through our site by our advertising partners. They may
be used by those companies to build a profile of your interests and show you
relevant adverts on other sites. They do not store directly personal
information, but are based on uniquely identifying your browser and internet
device. If you do not allow these cookies, you will experience less targeted
advertising.

Back Button


BACK



Search Icon
Filter Icon

Clear
checkbox label label
Apply Cancel
Consent Leg.Interest
Switch Label label
Switch Label label
Switch Label label

Reject All Confirm My Choices