Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shrinking database
Message
 
 
À
01/09/2010 23:13:42
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01479719
Message ID:
01479748
Vues:
45
>I removed about 95% of the size of the database by removing a lot of tables. The size should have been decreased to about 5 MB from 11 GB. However, after the operation, the database is still as big. I used the SHRINK DATABASE command but that didn`t change anything. I also restarted the service.

Use Shrinkfile command instead. Read comments to this blog:
Shrink log in all user databases
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform