Méthode Shrink
Réduit la base de données.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Sub Shrink ( _
percentFreeSpace As Integer, _
shrinkMethod As ShrinkMethod _
)
'Utilisation
Dim instance As Database
Dim percentFreeSpace As Integer
Dim shrinkMethod As ShrinkMethod
instance.Shrink(percentFreeSpace, shrinkMethod)
public void Shrink(
int percentFreeSpace,
ShrinkMethod shrinkMethod
)
public:
void Shrink(
int percentFreeSpace,
ShrinkMethod shrinkMethod
)
member Shrink :
percentFreeSpace:int *
shrinkMethod:ShrinkMethod -> unit
public function Shrink(
percentFreeSpace : int,
shrinkMethod : ShrinkMethod
)
Paramètres
- percentFreeSpace
Type : System. . :: . .Int32
Valeur Int32 qui spécifie de combien réduire la base de données en pourcentage.
- shrinkMethod
Type : Microsoft.SqlServer.Management.Smo. . :: . .ShrinkMethod
Valeur de l'objet ShrinkMethod qui spécifie la méthode utilisée pour réduire la base de données.
Notes
You can use the Shrink method to reduce the size of the files that make up the database manually. The data is stored more densely and unused pages are removed. Alternatively, you can shrink the database automatically at intervals by setting the AutoShrink option.
Exemples
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Shrink the database without truncating the log.
db.Shrink(20, ShrinkMethod.NoTruncate)
'Truncate the log.
db.TruncateLog()
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$db.Shrink(20, [Microsoft.SqlServer.Management.Smo.ShrinkMethod]'NoTruncate')
$db.TruncateLog()