QAD BI v3 - Tech Level 2 Certification - Part 4 > Disk Space Issues > Running Out of Disk Space – log file
  PPT
Running Out of Disk Space – log file
 
Shrink can run for a very long time, potentially even months in this instance. In this case, it’s even more difficult because of the lack of disk space.
The actual database is too big to move, but the log file could be moved.
Running Out of Disk Space – log file
 
In SSMS, you can also right-click on the database name and select Tasks then Take Offline option.
Running Out of Disk Space – log file
Running Out of Disk Space – log file
 
In SSMS, you can also right-click on the database name and select Tasks then Bring Online option.
Running Out of Disk Space – log file
Running Out of Disk Space – log file
 
You can see that the date stamp on the log file on the C:\ drive is now the same as the data stamp of the database on the E:\ drive. It is now safe to delete the log file from E:\ drive and free up nearly 178 GB of disk space.
Running Out of Disk Space – log file
Running Out of Disk Space – log file