Sample Header Ad - 728x90

SQL Server ERRORLOG way too big

1 vote
2 answers
4429 views
I'm running SQL Server 2014 on a VPS with 150Gb SSD. Today, I found that my hard disk was full 100% and there's a very large file from SQL Server Error log that was 45.7Gb. I tried manually delete the file, but Windows says the disk space doesn't change at all. How can I delete this file? I don't need the error log data, it's fine for me to delete it and regain the disk space. enter image description here I checked the file; it is so large due to failed login attempts. But here I want to delete the file first, these following commands didn't delete it, could u please give me some ideas?
Asked by Liberty (111 rep)
Aug 23, 2020, 09:51 AM
Last activity: Aug 15, 2023, 07:10 AM