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 listvalue
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.