• Space will not release once it has been consumed, this is due to the expensive procedure of allocating more space to files.

    If it grew to 5GB it will stay at 5GB unless you manually restart SQL or if possible run DBCC SHRINKFILE as per the article I provided earlier.