Make a shrink of its database
This article has been created by an automatic translation software. You can view the article source here.
Perform a shrink a database or file
Description
As a first step we need to explain the usefulness of the method Shrink. The latter is useful in order to liberate free space contained within the SQL Server files, and this in order to free the space.
Method
You choose as a first step that you want shrinker, you have two choices for this :
The first Database that consists of a shrink overall all of the core files.
The second Files which leaves the choice of the file you want shrinker.
You can access the options of shrink right-clicking on the basis you want to manipulate :
In the case of the election by file then you will have the following interface, just you here that to choose the file you want.
Then you can click on ok leaving the other default options.
File:Choix parametre Shrink.jpg
The second choice is shrinker base in full at once.
This will make the shrink on the set of files used by the base.
If the SHRINK seems not effective, try to pass the recovery model single in Properties > Options then press to full Once the shrink fact.
Enable comment auto-refresher