In this type of backup, the log records that have not been backed up are captured. This prevents data loss and maintains the log chain sequence.
The term, “tail” implies that it is the end of the log backup sequence.
If the database is damaged, it is recommended to create a tail-log backup to enable you to restore the database to the current point in time. A tail-log backup is used to capture all log records that have not yet been backed up. This will help in preventing any data loss and to keep the log chain complete.
Transaction log backup
Click on below link to watch the video::
::: Related Video links (Click below links to watch them) :::
a) Types of backup in sql server : • Types of Backup in SQL...
b) Fullbackup : • Full Backup in SQL ser...
c) Differential Backup : • Differential Backup in...
d) Transaction Log backup : • Transaction Log backup...
Do watch full video and subscribe the channel for more videos.
Негізгі бет Tail Log Backup in SQL Server || When to take a Tail log backup || Ms SQL
Пікірлер: 8