Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The Disk Usage report is showing lots of unused transaction log space (seems normal, there are hourly log backups). However the data file is mostly indexes and there is very little unused space. Is this normal?

enter image description here

share|improve this question
up vote 2 down vote accepted

Unless you have manually expanded the database to a size which is larger than that of the database's data size there won't be any free space within the data file. As the file files the file will be expanded based on the auto growth setting of the data file.

share|improve this answer
Autogrowth is currently set to 1MB, unrestricted. Good or bad? – Marcus Dec 6 '12 at 11:56
That would be bad. I typically recommend getting the autogrowth to 1 Gig unrestricted. That way it'll grow quickly enough without growing very often. – mrdenny Dec 6 '12 at 11:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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