MS SQL Server transaction log related activities
Perform the following activities to improve the performance and the reliability of your environment.
- Shrink the transaction log once a month. If the environment is large, it is advisable to shrink
the log after every data import.
For more information, see: How to: Shrink a File (SQL Server Management Studio).
- The transaction log in MS SQL Server records all transactions and the database changes caused by
For information how to configure the database transaction log, see: Move the Database Transaction Log to Another Drive.