Microsoft SQL Server and Sybase Tuning Recommendations › Database Tuning Parameters › Transaction Log

Previous Topic: Database Tuning Parameters

Next Topic: Threshold Procedures

Transaction Log

The transaction log keeps a before and after image of each change made in the database. Microsoft SQL Server keeps a transaction log for each database.

Back up the transaction log frequently. This keeps the transaction log small and reduces the amount of data lost in the event of a severe database corruption.