SQL Server Transaction Log reader tool to view, analyze, and edit SQL transaction logs

A brief overview of the SQL Transaction Log Reader Tool, that lets you view and analyze SQL Server transaction logs and recover data from them.
With dbForge Transaction Log, you can:

• View SQL Server transaction logs
• Search transactions for a specified time range
• Analyze change history based on the specified DML types
• Generate Undo/Redo sequel scripts for transactions

Find more information about dbForge Transaction Log here: https://www.devart.com/dbforge/sql/transaction-log/

For downloading a trial version visit: https://www.devart.com/dbforge/sql/transaction-log/download.html

Subscribe to our channel:
https://www.youtube.com/user/DevartSoftware/

#SQLServerTransactionLog
#SQTransactionLogReader
#SQLServer
#dbForge
#Devart

---

Closed Caption:

Transaction Log is a tool that allows you to analyze transaction logs and get
information about changes in databases.
With dbForge Transaction Log, you can:
- View sequel Server transaction logs
- Search transactions for a specified time range
- Analyze change history based on the specified DML types
- Generate Undo/Redo
SQL scripts for transactions
In this video, we'll look at how Transaction Log
can be used to rollback changes in a database
The script adds, updates, and
deletes two records in the CreditCard table.
After these operations are performed,
the CreditCard table will contain 4 records.
If the recovery
mode of this database is Full Recovery, we can recreate its state by analyzing
the transaction log.
Let’s look at how executed operations are displayed in
dbForge Transaction Log.
On the wizard’s first page, we need to select the .mdf file
of the database for which we would like to read the transaction log.
On the second page, we can select the time range for the log file and specific operation
types we would like to see. As we made our changes a few minutes ago, let’s set
the time range by selecting the current date and the approximate time when
changes were made. For demonstration purposes, we’ll display all DML operations.
After reading the transaction log, you can see all INSERT, UPDATE, and DELETE
operations displayed in the data grid.
Here you can sort, group, and filter the
data by necessary columns.
When an operation is selected, you can see
the following information in the grid’s lower part:
-- transaction properties
-- redo script
-- undo script
To generate a script for the entire log file, we need to
select the Export Script option and click ‘Export Undo Script’
To restore the
data to its original state, we need to execute the resulting script when
the database will be in online mode.
Download a trial version of dbForge Transaction Log
and see for yourself how simple it can be
to restore data with the help of transaction logs.
We highly appreciate
your opinion. Please send your feedback and help us keep improving.