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.

свернуть