coryfiala.com
How to shrink LDF File SQL Management Studio SCCM - Cory Fiala
Recently noticed my SCCM server data drive was running out of space. Didn’t make sense as we haven’t added anything substantial lately or used USMT. Installed WinDirStat and found the culprit to be a 400GB .ldf log file from SCCM. The fix was pretty painless and takes less than 10mins. Backup the database Stop the database service Shrink …