Transaction Log backup || Log file shrink || Difference b/w differential and Log backups || Ms SQL

A transaction log file stores a series of the logs that provide the history of every modification of data, in a database. It backs up the transaction logs of a database. This backup type is possible only with full or bulk-logged recovery models. Contents in this video: 1) How to take a T-log backup using T-SQL query and GUI 2) Why do we perform shrink operation on transaction log file ? 3) Difference between differential backup and T-log backup. ::: Related Video links (Click below links to watch them) ::: a) Types of backup in sql server :    • Types of Backup in SQL Server || Ms SQL   b) Fullbackup :    • Full Backup in SQL server || Append & Over...   c) Differential Backup :    • Differential Backup in SQL server || DCM p...   Do watch full video and subscribe the channel for more videos.