Home Forums SQL Server 2016 SQL Server 2016 - Administration Ginormous Production Log File - Help! RE: Ginormous Production Log File - Help!
andreas.kreuzberg
SSCertifiable
Points: 6183
More actions
March 13, 2018 at 7:37 am
#1982921
Hi,a backup won't shrink you logfiles. The internal LSN are marked for reuse.
Try to look the usage of your logfileDBCC sqlperf (logspace)
DBCC sqlperf (logspace)
If there is free enough space, feel free to shrink your logfile.