Central Tabulator Audit Log, 2008-11 Election

_RegistrarOfVoters (2008-12-03) _

This Page: https://https://copswiki.org/Common/M831

More Info: ElectionIntegrity

• 20.11_AVServerLog.log_November_2008.txt: Gems Server Audit Log, 2008-11 Election

• 20.11_AVServerLog.log_November_2008_edit.txt: Gems Server Log, Edited for Readability, 2008-11 election

• AuditLog-CardsReadLinesOnly.txt: Reduced audit log only lines showing vote reads and ballot counts.

We would actually like to have access to the Transaction Log, which would detail every transaction to the database. Here is some information on this topic of investivation:

Transaction Logs on Microsoft SQL server

(From Microsoft SQL Server transaction log tutorials)

Every SQL Server database has its own transaction log that keeps a record of all data modifications in a database (insert, update, delete) in the order in which they occur. This information is stored in one or more log files associated with the database. The information stored in these log files cannot be modified or viewed effectively by any user process.

SQL Server uses a write-ahead log. The buffer manager guarantees that changes are written to the transaction log before the changes are written to the database. The buffer manager also ensures that the log pages are written out in sequence so that transactions can be recovered properly in the event of a system crash.