Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE DB size go up fast
Message
From
17/10/2005 03:06:37
 
 
To
17/10/2005 02:40:32
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01059046
Message ID:
01059555
Views:
8
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform