sql 2008 database has suddenly grown huge
Posted on 2014-01-18
We've had a package for our website that uses sql for about 7 years. The database was usually around 25 gb in size. Suddenly it has grown to 90 gb and I can't figure out why or how to fix it. It isn't the log that is huge - its the actual db. I can see the largest file is "portal" but I don't know what that file is. It isn't listed under the table view. We haven't done anything differently with the site over the past few months - in fact we've deleted a lot of old images. I thought about shrinking the db (even though some don't recommend that), but it looks like that would only affect about 6% of the space. I have no clue what to do but need to reduce the size of this db quickly.