I have a SQL erver 2005 database which was ibeen collecting data over the last 6 years.
The DB and log files were in the 60 Mb range a couple of months ago. I just noticed that the DB is now 1.2 Gb and growing and the Log file is at 95 Mb.
I found a table that was duplicating data every time a user's action was initiated. I did this:
1. Deleted the table
2. re-created the table
3. fixed the issue to keep the appropriate data inserting into the new table
I checked all other tables and found no similar issues...
I then shrank the DB and log file with
DBCC SHRINKDATABASE (My_Database, 10);
DBCC SHRINKFILE (My_Database_Log, 10)
This got the DB size down to 540 Mb and the log file down to 15 Mb.
I still think there may be something else going on?
Does anyone know how I can get the file size down further and how to maintain it at the optimum size?