QAD BI v3 - Tech Level 2 Certification - Part 4 > Disk Space Issues > Running Out of Disk Space – Shrink Option
  PPT
Running Out of Disk Space – Shrink Option
 
Files reside in the E:\SQLData directory.
Note that the Autogrowth was set at 1 MB, which means that if the database grew from 1 GB to 1100 GB, it had to Autogrow a million times. This should be set appropriately, like 10% or 100 GB.
Running Out of Disk Space – Shrink Option
Running Out of Disk Space – Shrink Option
Running Out of Disk Space – Shrink Option
 
You can see how much space the database is taking up, how much available free space there is and what percent of the total amount of allocated space it is. Click ok to accept default settings to continue.
Running Out of Disk Space – Shrink Option
Running Out of Disk Space – Shrink Option
 
Using this query, you can see how long it will take to finish.
Note that the status frequently will be displayed as suspended. Re-executing the query multiple times may show that the status is running.
These results were produced after a different shrink methodology was run. The actual shrink database results for this customer only completed about 30% of after 4 days, it started to look like it would take months to finish the shrink database option.