A collection of articles covering SQL log, SQL Server logs and transaction log topics
General auditing
- Read a SQL Server transaction log
- Open LDF file and view LDF file content
- Audit SQL Server database schema changes
- Audit SQL Server database security changes
- Audit SQL Server permission changes to improve overall security
- How to audit your auditing in SQL Server – tracking when triggers are disabled
- SQL Server transaction log reader use cases
- Restore a database to a point in time – part 1
- How to recover deleted SQL data from transaction logs
- Using a SQL log analyzer to audit, replicate and recover data
- Top features you need in a SQL Server transaction log reading solution
- Synchronizing databases using the transaction log – SQL Server Log shipping
- Automating daily transaction log reading
Forensic auditing
- Checklist for suspicious activity on SQL Server
- SQL Server database Forensic auditing including row history and before-and-after auditing
- SQL Server true detective – Solving the case of the broken database
DDL auditing
Before and after auditing
Disaster recovery
- How to recover from a SQL Server database data-file corruption disaster
- Recover a SQL Server database using an old backup and the current transaction log file
- Recover a SQL Server database using only a transaction log file (.ldf) and old backup files
- How to recover views, stored procedures, functions, and triggers
- 4 techniques for recovering lost tables due to DROP Table operation
- Recover deleted records in Dynamics CRM 2016
- Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server
- How to automatically revert database changes based on SQL auditing alerts using SQL Server transaction logs
Row-level recovery
- How to recover SQL Server data from accidental UPDATE and DELETE operations
- Recover deleted SQL data from transaction logs
- How to recover SQL Server data from accidental updates without backups
- SQL Server disaster recovery – How to quickly recover data lost due to an Inadvertent delete operation
Point in time recovery
- Reverting your SQL Server database back to a specific point in time
- Using SQL Server database snapshots to protect yourself against accidental data modification
SQL injection attacks
- How to recover objects that are missing as a result of a SQL injection attack
- How to recover data that is missing or damaged as a result of a SQL injection attack
No downtime/data loss migrations
