Thank you, thank you, thank you! Here was my command for our MSDB log file going out of control. After determining that our Simple recovery model database was acting like a full rcovery db:
SELECT name, log_reuse_wait_desc FROM sys.databases
log_reuse_wait_desc = Replication
I forced removal of the replication (must have been caused during a restore at some point).
EXEC sp_removedbreplication msdb
Reran the following:
SELECT name, log_reuse_wait_desc FROM sys.databases
Forced to Simple Recovery (just to make sure):
ALTER DATABASE msdb SET RECOVERY SIMPLE
Ran standard shrink commands (found all over google or our favorite search engine 😉 )
backup log msdb with truncate_only
dbcc shrinkfile(MSDBLog)
Chicka chicka boom boom...now there's enough room!