I have done a delete operation on a table with many records, so my log file grew from 15 GB to 58 GB. At some point I canceled the execution of delete query because my hdd was running out of space. I have seen here how to delete this big amount of data. My question is how could I reduce the size of log file back to 15 GB?
1 Answers
If you use a full recovery model, then you are essentially preserving all the history of your database in your logs.
Most likely you want to switch to simple recovery model, followed by DBCC SHRINKFILE as others have suggested.
Related