On my production database, the .mdf file is rapidly growing on a daily basis.

If I change the recovery model from SIMPLE to FULL, will that help?


the simple recovery model only affects the log files of your database (.ldf).

If your datafiles are growing, you can check the tables that are occupying more space, you can use the management studio: right click on the database> reports > standard reports > disk usage by top tables

this way you can determine which table is taking all the space and plan a cleanup task for that (or move data to another DB)


how does your transaction logs grows .could you provide more info like

  1. what is your current recovery model ?

2.how often you take full backup and log backup ?

3.do you have auto growth settings ?

If the problem is T-LOG growth,start with http://www.sqlservercentral.com/stairway/73776/

  • OP indicates that it's a problem with their MDF file, which more than likely (although not guaranteed) to be their data file. – Nic Sep 22 '17 at 14:36

Not the answer you're looking for? Browse other questions tagged or ask your own question.