June 30, 2015 at 3:19 pm
if mdf get full by data then how to make free space without adding disk.
June 30, 2015 at 3:43 pm
You could look at:
- data compression
- dropping unused indexes
- deleting data that is no longer needed
- dropping, or truncating, temp tables that are no longer needed
- archiving old data to another database, on another drive
Be careful before deleting or dropping anything.
The above can only provide temporary relief, if any at all. Eventually, you will likely need more disk space.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 1, 2015 at 3:35 am
Hi,
To continue on from the good advice of the previous post.
You might want to look capacity planning.
Look at the tables that grow the quickest and the causes of this. Also look at processes that log data if you have any. You maybe storing data that is out of data or useless.
A final thought, have you run out of disk or is your data file being constrained by it's growth model. It could be that you just need more disk and this is something that capacity planning would reveal before you got to this point.
Graeme
July 1, 2015 at 6:07 am
You could also look at your file growth settings? is the default at 10% still? think how bad that is when you start reaching big sizes?
Maybe set the rate of growth to a fixed amount, like 100MB or 500MB etc., instead of the default 10%.
Look for a report called EM Task Pad, this will show you how much of that data file you are actually using.
Maybe look at resizing the file and then reorganizing your indexes etc.
Inevitably, you will need to either increase the existing disk, or extend the data file onto separate disks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply