Using transaction logging

Transaction Logging creates a log file of all database transactions that you perform. You can use this file to recreate a damaged or lost database. However, transaction logging significantly slows the sys tem. Use it as a temporary safeguard, during network problems or when you change network hardware.

During normal operation, recommended to follow a good backup regimen.

Microsoft SQL Server handles transaction logging. ​