I have a database that has 1 table in particular that stores a copy of a signed and populated completed pdf form in an Image column. When the front end application completes it's session, this completed pdf record gets copied to a new table and becomes the most recent "final copy" version for that hire record. Over time, this completed forms table has grown pretty large because each "session" could have say 10 pdf's that could be 1mb each. Now to me, having 20-30 gb of blob "temporary" records sitting out there seems excessive. I can't re-engineer the process, but I can add a step to remove the completed forms from the table once they are persisted to the hire record. But, this doesn't recliam any physical drive space. The DB is currently 165GB of which approx 2/5ths is completed forms, 2/5ths is the persisted "final copy", and 1/5th is normal data. How can I reclaim this 2/5th space after removing the "temporary" records, and how can I keep it "trimmed down" so it doesnt grow back?
I hope all of that made sense to you. THanks in advance.