Make a shrink of its database
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 :
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