I'm sorry to say, but what you are saying here does not make any sense. How you describe the transaction log backup is in essence a differential backup. Performing regular transaction log backups as you describe here is virtually the same as performing differential backups (in the simple recovery model). If you totally loose the data and log files you still only have the last backup to go back to. There are lot of other reasons to choose the full recovery model but what you are describing here is just differential backups.
Thanks for the content! You make it always so easy to understand!
You are very knowledgeable and able to communicate it well. I enjoyed watching your videos.
Is marker is expensive for you if not can u please good marker so we can see clearly
I like the selection of examples and the timeline sketch to explain the impact of the recovery model. You did not just dive into SSMS.
Best SQL videos on RUclips! Thank you!
hi, if possible tail log backup and restore last one with recover
0% data lost
Very useful, thanks a lot.
Hello thank you so much it is very simple and clear to understand.
hey, thanks for the videos
This guy rocks
Thanks! :-)
nice video as always. p.s.: "occured" is more likely to be pronounced like "OKÖÖAD" and not like "OKUUAD" ;)
I'm sorry to say, but what you are saying here does not make any sense. How you describe the transaction log backup is in essence a differential backup. Performing regular transaction log backups as you describe here is virtually the same as performing differential backups (in the simple recovery model). If you totally loose the data and log files you still only have the last backup to go back to. There are lot of other reasons to choose the full recovery model but what you are describing here is just differential backups.
Thank you for your good explanation. can you describe difference between differencial back up and transaction log backup please?