共用方式為


Initialize Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

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

語法

object
.Initialize [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetInitialize(LPBOOL pRetVal);
HRESULT SetInitialize(BOOL NewValue);

備註

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 and appends it as the last backup set on the media.

Applies To:

Backup Object

請參閱

參考

BackupSetName Property

其他資源

BACKUP (Transact-SQL)

說明及資訊

取得 SQL Server 2005 協助