SQL- Server – Free disk SPACE USING SHRINK
Understanding shrinking the log If you need to recover disk space from the transaction log file , consider shrinking the log file. Shrinking logs helps after you perform an action that creates a large number of logs. You can only shrink the log if there is free space on the log file. Shrink the transaction log Use the following steps to truncate the transaction log file: 1. Right-click the database and select Tasks -> Shrink -> Files . 2. Change the type to Log . 3. Under Shrink action , select Release unused space and click OK . What if the log size does not decrease? If the size of the log does not change much after this, it means that your database has the recovery mode set to Full and there is not enough unused space to recover. At this point you can consider the option to delete all logs by “temporary” set the database Recovery mode to Simple and try another shrink. But...