Transaction log. Review recommendations for SQL Server and Virtual Machines. SQL Server is a Microsoft product, and SolarWinds can thus provide only general, experience-based recommendations. The Orion Platform writes a large number of small writes to the SQL database. SQL Server transaction logs contain records describing changes made to a database. They store enough information to recover the database to a specific point in time, to replay or undo a change. But, how to see what's in them, find a specific transaction, see what has happened and revert the...When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you This video illustrates how to take Transaction Log backup (T-Log) of a database in sql server 2005, 2008, 2012 and 2014 using SQL Server...Oct 29, 2015 · The transaction log is an essentially huge topic and a couple of articles is not sufficient to unveil all the details. So if you want to get more detailed information, I would suggest you to read the following book: SQL Server Transaction Log Management by Tony Davis and Gail Shaw and this article: Transaction Log Management. Also read: Nov 16, 2012 · Learn everything there is to know about how logging, recovery, and the transaction log work so you can avoid and recover from transaction log problems, applicable for anyone responsible for SQL Server, from SQL Server 2005 onwards. The logging and recovery mechanism is one of the most misunderstood parts of SQL Server, but it's one of the most critical for you to understand.