Transaction Log backup || Log file shrink || Difference b/w differential and Log backups || Ms SQL
Vložit
- čas přidán 24. 08. 2024
- 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...
b) Fullbackup : • Full Backup in SQL ser...
c) Differential Backup : • Differential Backup in...
Do watch full video and subscribe the channel for more videos.
Nice video balui like your voice and way of explaining the things
Excellent explanation hats off to you bravo
Excellent explanation.
very goog explaination sir with diagrams thank you so much
As usual the best ❤
THANKS, MERY MUCH HELP
Really ur explaination is too good ,
Ur voice to be increased
Well explained, Thanks.
Nice video 👍
How to get to know travel is on or off
Sir your videos explain these topics well. In your future video could you include the sql code your write so it would be easier to follow along with you. Thank you
Sure, I will be sharing the SQL code in the video description. Please check my latest ones.
very understandable
Super 👌 👍 😍
Nice video sir
I have a one doubt you have changed database from simple to full then you took the log backup . Then you will change from full to simple previous process is going or anything happened. My environment 7gb database is in simple recovery mode .but i change from simple to full it is working .i won't to change my database from full to simple then any happened .pls let me know...
I have a database with
* record 1
* record 2
* record 3
Then I delete
* record 1
* record 2
Next, I add
* record 4
* record 5
* record 6
How to backup and restore to have full record
* record 1
* record 2
* record 3
* record 4
* record 5
* record 6
Is the log backup and incremental back are same.
No
Any video on migration 2012 to 2017 pre requisites and post requisites
I will do it as soon as possible
I have o e doubt here.. for every log backup do we need to manually clear the space to release disk space?
You can schedule the job to do it.
@@righttolearnbk is there any script to check whether log backup is enabled or not? Instead of checking in gui
Bcz in my work place i dont have an access to check this via gui.. that option is disabled.. i am looking for a scripts to check on that.
Does shrinking the log file breaks the log chain
No. Shrinking log file releases space to the disk
Very nice explanation.Please share the all trainings links or blog name@@righttolearnbk