Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shrinking a test database
Message
 
 
À
03/05/2016 12:51:12
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows 2008 Server
Divers
Thread ID:
01635776
Message ID:
01635781
Vues:
51
What is DB recovery mode? How do you shrink DB?

>I am working with a test database and, after a few operations which caused the database to grow very huge, I need to shrink that back to its original state.
>
>The first image shows the size used by various files. We can see the biggest one is 5 GB.
>
>The second image shows that I cannot make that database diminished under 44 GB.
>
>So, I tried various things but I cannot diminish that database. Something is reserving a lot of space.
>
>Anyone would have an idea what I could try to really bring that back to its original state?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform