Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shrinking a test database
Message
From
03/05/2016 13:00:42
 
 
To
03/05/2016 12:51:12
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows 2008 Server
Miscellaneous
Thread ID:
01635776
Message ID:
01635777
Views:
55
>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?

DBCC?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform