Database.Size Property

Syntax

'Deklaracja
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public ReadOnly Property Size As Double

[SfcPropertyAttribute(SfcPropertyFlags.Expensive)] 
public double Size { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Expensive)] 
public:
property double Size {
    double get ();
}

/** @property */
public double get_Size ()

public function get Size () : double

Property Value

A Double value that specifies the database in MB.

Remarks

The size is specified in megabytes and should be the same as when the database was originally created unless you have opted to automatically grow or shrink the database. The space allocated in the database can be determined by using the SpaceAvailable property.

Example

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'Display size and space information for the database.
Console.WriteLine("data space usage (KB): " + _
db.DataSpaceUsage.ToString)
Console.WriteLine("index space usage (KB): " + _
db.IndexSpaceUsage.ToString)
Console.WriteLine("space available (KB): " + _
db.SpaceAvailable.ToString)
Console.WriteLine("database size (MB): " + _
db.Size.ToString)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

See Also