Difference between revisions of "Make a shrink of its database"

From EN Ikoula wiki
⧼vector-jumptonavigation⧽ ⧼vector-jumptosearch⧽
Line 1: Line 1:
−
<span data-link_translate_fr_title="Faire un shrink de sa base de données"  data-link_translate_fr_url="Faire_un_shrink_de_sa_base_de_donn%C3%A9es"></span><br />[[:fr:Faire un shrink de sa base de données]][[fr:Faire un shrink de sa base de données]]<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 />
+
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">shrink</span> ====
  
−
===== Description =====
+
===== =====
−
As a first step we need to explain the usefulness of the method <span class="notranslate">Shrink</span>.
+
<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 :
 
  
−
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.
+
<span class="notranslate">shrink</span>
  
  
−
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.
+
 
−
This will make the <span class="notranslate">shrink</span> on the set of files used by the base.
+
<span class="notranslate">shrink</span>  
  
 
[[File:Validation_Shrink.jpg]]
 
[[File:Validation_Shrink.jpg]]
  
  
−
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.
+
<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>  
  
 
[[File:Shrink_backup.jpg]]
 
[[File:Shrink_backup.jpg]]
−
<span data-translate="fr"></span><comments />
+
<comments />

Revision as of 09:01, 24 September 2015


This article has been created by an automatic translation software. You can view the article source here.

shrink

Shrink.


shrink



shrink :

File:Chemin Shrink.jpg



File:Choix parametre Shrink.jpg


shrink

File:Validation Shrink.jpg


SHRINK recovery model Properties > Options full shrink

File:Shrink backup.jpg


You are not allowed to post comments.

Retrieved from "https://en-wiki.ikoula.com/index.php?title=Make_a_shrink_of_its_database&oldid=824"