Initialize Property (SQL-DMO)

The Initialize property controls backup device append/overwrite behavior for a backup to one or more specified devices.

Applies To

Backup Object

Syntax

object.Initialize [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

Remarks

If True, the backup specified becomes the first backup set on the media, overwriting any existing backup sets on the media. The backup media is not overwritten if either of the following conditions is met:

All backup sets on the media have not yet expired.
The optionally specified backup set name does not match the name on the backup media. Specify backup set name with the BackupSetName property

If False, the backup specified creates a new backup set appended as the last backup set on the media.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetInitialize(LPBOOL pRetVal);

HRESULT SetInitialize(BOOL NewValue);