I had a HUGE dilemma, my DB server locked up because the HDD filled up due to the transaction log file getting over 50GB (Daaamn!)

Now, I am not a DB admin… at all. So I turned to Google. I was told to run DBCC Shrinkfile and all would be ok. Wrong. Nothing Happened. Turns out, my database was somehow stuck in Replication mode for the log_reuse_wait_desc in sys.databases. After a few days of Google-scrounging, I foud this gem:

Run this scheduled task: sp_removedbreplication

No i backed up my database, and then ran the DBCC Shrinkfile command and BAM! It’s all good now =)

.: Adam