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.
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
Last activity: Aug 15, 2023, 07:10 AM