Shrink Sql Server Log files on Production Databases

If anyone is looking for Sql DBA training, Job Support, Interview Support, Videos, Notes Please Whatsapp me @ 9902590140
Thank You Queries used in this video
dbcc sqlperf(logspace)
Backup log DBName to disk ='nul'
replace DBName with your respective database name

[jammidba]

This is very helpful video. The concept is very clear. Thank you so much

[ravidba-cm]

thank you very much, sir. explain like this. your videos are very helpful

[sravzsure]

This is very helpful vedio👍.the concept is very clear. Thank you so much 🙏🙏🙏

[khadeerahmed]

Real time day to day common issues videos make it. It will be usefull in real time job.

[mysuggestionshub]

Thank you so much bro. It helped me a lot

[govardhankondreddy]

If didn't mine, performance tuning videos cheyandi bro

[shyamdular]

Sir you siad, you will uoload another video on datafile shrinking process.when can we expect this video

[saivijayendranadhcherukuri]

xp_fixeddrives

dbcc sqlperf(logspace)

select name, log_reuse_wait_desc from sys.databases


backup log dbname to disk='nul'

[kamalbasha-cbnm]

Thank you for valuable information sir
If I shrink a log file but the log file willl not shrink what we do sir

[smart-vhxs]

I have one doubt.Database simple recovery mode what steps will follow to shrink log backup....!!

[nagarajuvallepu]

have you created a video for how to deal with datafiles shrink

[sivakumarambulapodi]

Tq Shankumh...how to shrink datafiles?will such a situation come in real-time?

[DevaKumar-hoqo]

If we want to retrieve the log back up from Nul, Is ti possible ? if Yes, How we can do?

[avulasatishpatel]

Hi bro
Please do performance tuning and cpu utilisation please

[ksrinivasrao]

If this is log_reuse is due to mirroring we can do this ???

[azuredevops]

Please upload slow running queries trouble shooting video

[JigneshPatel-iyyn]

Can we srink the database...?? Instead of log file?? How we can reduzce the size of database?