I have a IIS web server logging application that logs download activity is a MSSQL database. We are typically only interested in the past 30 days of records and our MDF file has grown pretty huge over the years and we are running out of disk space. I have archived all records older than 30 days making the record space 95% of what is used to be. I would like to reclaim all of the disk space of the MDF.
I know there is a lot of talk about not shrinking a database. So what's the best way to reclaim the physical disk space? Also, almost all of the transactions on this database are INSERT transactions.