I'm new to a project (DBA) that has an enormous database (850GB data, 20GB log) on a LUN with only 1.75 TB available. I've been told new storage may be available in March 2016(!). Problem is that the db has started growing 80 GB per day. I have full backups running every day, translog backups running every 3 hours. This db is hit constantly by four sets of data import feeds that cannot be taken offline for more than 2 hours. Also, I have 30 users performing large queries from the same db. I should also mention that the feeds utilize triggers that insert, update, and delete from tables that average 35GB each. The db has only 1 data file (like I said, I didn't design it, I inherited it).
The statistics for this db show 67% free in the db file, so, I'm unsure why it continues to expand. We need to reclaim this space (as mentioned no possible expansion for several months) or the instance will crash due to lack of space.
I know that a dbshrink on the file is not the best option, but, is it my only option given the circumstances? Any thoughts (other than get more space)?