I have a server that is running extremely low on disk space and I dug into to determine if something is not functioning properly or if it simply is a healthy database that just happens to be growing.
I discovered that an ldf for a particular DB has reached 116gb (more than half the available space on the drive). However everything seems to be operating as it should in order to properly maintain the ldf size:
-Nightly Full backups -Morning log backups
I also tried shrinking the ldf to free any unused space and got almost a single mb back. All things considered would this be a case where we just need to either A)increase disk space or B)move this DB's ldf to a different location?
Any feedback is greatly appreciated!