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 : [ Ссылка ]
b) Fullbackup : [ Ссылка ]
c) Differential Backup : [ Ссылка ]
Do watch full video and subscribe the channel for more videos.
