Index fill factor is default (80% I presume); average fill of pages 89%; the empty database is identic with first database in every aspect - same script to create.
To me it seems like the deleted records are left in place and take space instead to be rewriten with new records.


>>No, the file are correct.
>>
>>Enmanuel,
>>In shrink dialog there are no free space reported and when I choose shrink it don't shrink the file.
>>
>>However, if I make a DTS and export all data to another empty database, the new database is only 535MB in size instead of 2024MB
>>
>
>Every MDF has a average ratio of filling of the pages, what it depends:
>- info columns : it depends on the relationship ROWSIZE/8060
>- indexes : it depends of the declared ratio filling
>In your case it seems to be of 25%.
>To this point you have to check the design of the database.