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

From EN Ikoula wiki
⧼vector-jumptonavigation⧽ ⧼vector-jumptosearch⧽
(Created page with "This article has been created by an automatic translation software. You can view the article source here.<br /> ====Perform a <...")
 
 
(18 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
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-link_translate_en_title="Make a shrink of its database"  data-link_translate_en_url="Make a shrink of its database"></span>[[:en:Make a shrink of its database]][[en:Make a shrink of its database]]
 +
<span data-link_translate_he_title="להפוך פסיכולוג של מסד הנתונים שלה"  data-link_translate_he_url="%D7%9C%D7%94%D7%A4%D7%95%D7%9A+%D7%A4%D7%A1%D7%99%D7%9B%D7%95%D7%9C%D7%95%D7%92+%D7%A9%D7%9C+%D7%9E%D7%A1%D7%93+%D7%94%D7%A0%D7%AA%D7%95%D7%A0%D7%99%D7%9D+%D7%A9%D7%9C%D7%94"></span>[[:he:להפוך פסיכולוג של מסד הנתונים שלה]][[he:להפוך פסיכולוג של מסד הנתונים שלה]]
 +
<span data-link_translate_ru_title="Чтобы сжать его базы данных"  data-link_translate_ru_url="%D0%A7%D1%82%D0%BE%D0%B1%D1%8B+%D1%81%D0%B6%D0%B0%D1%82%D1%8C+%D0%B5%D0%B3%D0%BE+%D0%B1%D0%B0%D0%B7%D1%8B+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85"></span>[[:ru:Чтобы сжать его базы данных]][[ru:Чтобы сжать его базы данных]]
 +
<span data-link_translate_ja_title="そのデータベースの圧縮を行う"  data-link_translate_ja_url="%E3%81%9D%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE%E5%9C%A7%E7%B8%AE%E3%82%92%E8%A1%8C%E3%81%86"></span>[[:ja:そのデータベースの圧縮を行う]][[ja:そのデータベースの圧縮を行う]]
 +
<span data-link_translate_ar_title="إجراء تقليص قاعدة بياناته"  data-link_translate_ar_url="%D8%A5%D8%AC%D8%B1%D8%A7%D8%A1+%D8%AA%D9%82%D9%84%D9%8A%D8%B5+%D9%82%D8%A7%D8%B9%D8%AF%D8%A9+%D8%A8%D9%8A%D8%A7%D9%86%D8%A7%D8%AA%D9%87"></span>[[:ar:إجراء تقليص قاعدة بياناته]][[ar:إجراء تقليص قاعدة بياناته]]
 +
<span data-link_translate_zh_title="使其数据库收缩"  data-link_translate_zh_url="%E4%BD%BF%E5%85%B6%E6%95%B0%E6%8D%AE%E5%BA%93%E6%94%B6%E7%BC%A9"></span>[[:zh:使其数据库收缩]][[zh:使其数据库收缩]]
 +
<span data-link_translate_ro_title="Face un psihiatru de baza sa de date"  data-link_translate_ro_url="Face+un+psihiatru+de+baza+sa+de+date"></span>[[:ro:Face un psihiatru de baza sa de date]][[ro:Face un psihiatru de baza sa de date]]
 +
<span data-link_translate_pl_title="Zrobić zmniejszania bazy danych"  data-link_translate_pl_url="Zrobi%C4%87+zmniejszania+bazy+danych"></span>[[:pl:Zrobić zmniejszania bazy danych]][[pl:Zrobić zmniejszania bazy danych]]
 +
<span data-link_translate_de_title="Machen Sie eine Verkleinerung der Datenbank"  data-link_translate_de_url="Machen+Sie+eine+Verkleinerung+der+Datenbank"></span>[[:de:Machen Sie eine Verkleinerung der Datenbank]][[de:Machen Sie eine Verkleinerung der Datenbank]]
 +
<span data-link_translate_nl_title="Een krimp van de database maken"  data-link_translate_nl_url="Een+krimp+van+de+database+maken"></span>[[:nl:Een krimp van de database maken]][[nl:Een krimp van de database maken]]
 +
<span data-link_translate_it_title="Fare uno strizzacervelli del relativo database"  data-link_translate_it_url="Fare+uno+strizzacervelli+del+relativo+database"></span>[[:it:Fare uno strizzacervelli del relativo database]][[it:Fare uno strizzacervelli del relativo database]]
 +
<span data-link_translate_pt_title="Fazer um psiquiatra de sua base de dados"  data-link_translate_pt_url="Fazer+um+psiquiatra+de+sua+base+de+dados"></span>[[:pt:Fazer um psiquiatra de sua base de dados]][[pt:Fazer um psiquiatra de sua base de dados]]
 +
<span data-link_translate_es_title="Hacer un shrink de la base de datos"  data-link_translate_es_url="Hacer+un+shrink+de+la+base+de+datos"></span>[[:es:Hacer un shrink de la base de datos]][[es:Hacer un shrink de la base de datos]]
 +
<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>[[:fr:Faire un shrink de sa base de données]][[fr:Faire un shrink de sa base de données]]
 +
<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>
 +
 
 +
{{#seo:
 +
|title=Make a shrink of its database
 +
|title_mode=append
 +
|keywords=these,are,your,keywords
 +
|description=Make a shrink of its database
 +
|image=Uploaded_file.png
 +
|image_alt=Wiki Logo
 +
}}
  
 
====Perform a <span class="notranslate">shrink</span> a database or file ====
 
====Perform a <span class="notranslate">shrink</span> a database or file ====
Line 35: Line 60:
  
 
[[File:Shrink_backup.jpg]]
 
[[File:Shrink_backup.jpg]]
−
<span data-translate="fr"></span><comments />
+
<comments />

Latest revision as of 11:12, 28 September 2021

en:Make a shrink of its database he:להפוך פסיכולוג של מסד הנתונים שלה ru:Чтобы сжать его базы данных ja:そのデータベースの圧縮を行う ar:إجراء تقليص قاعدة بياناته zh:使其数据库收缩 ro:Face un psihiatru de baza sa de date pl:Zrobić zmniejszania bazy danych de:Machen Sie eine Verkleinerung der Datenbank nl:Een krimp van de database maken it:Fare uno strizzacervelli del relativo database pt:Fazer um psiquiatra de sua base de dados es:Hacer un shrink de la base de datos fr:Faire un shrink de sa base de données

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 :

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


The second choice is shrinker base in full at once. This will make the shrink on the set of files used by the base.

File:Validation Shrink.jpg


If the SHRINK seems not effective, try to pass the recovery model single in Properties > Options then press to full Once the shrink fact.

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=12043"