Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MSDE DB size go up fast
Message
De
17/10/2005 03:06:37
 
 
À
17/10/2005 02:40:32
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Roumanie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01059046
Message ID:
01059555
Vues:
9
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform