Link to home
Start Free TrialLog in
Avatar of jduran04
jduran04Flag for United States of America

asked on

SQL Server Database Primary Data File - Growing Exponentially

I received a notification on a disk drive hosting a SQL Server 2008 Standard/Windows 2008 R2 Standard - .mdf file.  The notification states that the server is running out of disk space.  12 hours ago, the available disk space was at 125 GB available.  Now there is only less than 50GB available and that .mdf file keeps growing.  is there any maintenance that can be run on the database side, rather than expanding the volume, and have the issue recur again?
ASKER CERTIFIED SOLUTION
Avatar of Mr Knackered
Mr Knackered
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Change the growth method from pecentage, which is defaulted at 10%, to a fixed value, say 512MB. In the Management Studio, expand database node > right click on the database > Properties > Choose Files in the left panel Files and change the Autogrouwth. 10% from 125GB is 12GB and that is a lot!
Here:
User generated image