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.