DataFileSize Property

SQL-DMO

SQL-DMO

DataFileSize Property

The DataFileSize property exposes the size of a Microsoft® SQL Server™ database used for replication distribution.

Applies To
DistributionDatabase Object
Syntax

object.DataFileSize [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a file size in MB

Data Type

Long

Modifiable

Read/write when using the DistributionDatabase object to create a replication distribution database. Read-only when a DistributionDatabase object references an existing SQL Server database.

Prototype (C/C++)

HRESULT GetDataFileSize(LPDWORD pRetVal);

HRESULT SetDataFileSize(DWORD NewValue);

Remarks

DataFileSize returns the current size of the primary file implementing a SQL Server replication distribution database.

Set DataFileSize to control the initial size of the database primary file created when using the DistributionDatabase object to create a SQL Server database for replication distribution.