SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.