Difference between revisions of "Make a shrink of its database"
| Line 1: | Line 1: | ||
| − | |||
<br /> | <br /> | ||
This article has been created by an automatic translation software. You can view the article source [[:fr:Faire un shrink de sa base de données|here]].<br /><span data-translate="fr"></span> | This article has been created by an automatic translation software. You can view the article source [[:fr:Faire un shrink de sa base de données|here]].<br /><span data-translate="fr"></span> | ||
| − | |||
| − | ==== | + | ====Perform a <span class="notranslate">shrink</span> a database or file ==== |
| − | <span class="notranslate"> | ||
| + | ===== Description ===== | ||
| + | As a first step we need to explain the usefulness of the method <span class="notranslate">Shrink</span>. | ||
| + | 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 : |
| − | <span class="notranslate">shrink</span> | + | The first Database that consists of a <span class="notranslate">shrink</span> 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 <span class="notranslate">shrink</span> right-clicking on the basis you want to manipulate : | |
| − | <span class="notranslate">shrink</span> : | ||
[[File:Chemin_Shrink.jpg]] | [[File:Chemin_Shrink.jpg]] | ||
| − | + | 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]] | [[File:Choix_parametre_Shrink.jpg]] | ||
| − | + | The second choice is shrinker base in full at once. | |
| − | <span class="notranslate">shrink</span> | + | This will make the <span class="notranslate">shrink</span> on the set of files used by the base. |
[[File:Validation_Shrink.jpg]] | [[File:Validation_Shrink.jpg]] | ||
| − | <span class="notranslate">SHRINK</span> <span class="notranslate">recovery model</span> <span class="notranslate">Properties > Options</span> <span class="notranslate">full</span> <span class="notranslate">shrink</span> | + | If the <span class="notranslate">SHRINK</span> seems not effective, try to pass the <span class="notranslate">recovery model</span> single in <span class="notranslate">Properties > Options</span> then press to <span class="notranslate">full</span> Once the <span class="notranslate">shrink</span> fact. |
[[File:Shrink_backup.jpg]] | [[File:Shrink_backup.jpg]] | ||
<comments /> | <comments /> | ||
Revision as of 09:08, 24 September 2015
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