asked
Database size increases
I Have one database and it has only two table not having more than 2 GB data then why database size is 40 GB..32 GB MDF and 9 GB LDF? Its database size increases daily almost 1 GB and its not having more transaction. Please help me .. How to decrease the size of MDF.
How is the database being used (if at all)? Are there any system processes that load data and clean it out again? Or is it just a static system?
You have some answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
Are you storing binary data (like photos or documents) in this database? Check if you have columns like 'varbinary' in your tables
Only two column has text field data type.... Is there any way to shrink the MDF file?
Are you sure there's only 2GB data in your database? (and not some binary data in the text column?). If so, do this: 1. in SSMS, right click on the databasename 2. goto Tasks -> Shrink -> Files 3. Select the datafile (file type: data) 4. select the "Reorganize pages before releasing unused space" and select a minimum filesize 5. click "OK" This might take some time ...
...and you might want to rebuild your indexes when you're done.
Thanks for reply, There is no Indexes .is there any issue comes in production database when shrink the data file? Can i shrink same for the production database??
yes, you can use the same steps for production. However, do this outside office hours to prevent blocking / performance issues
19 People are following this question.
