共用方式為


Restart Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The Restart property controls Backup and Restore object behavior when the backup or restore operation specified by the object is started and interrupted.

語法

object
.Restart [= 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 GetRestart(LPBOOL pRetVal);
HRESULT SetRestart(BOOL NewValue);

備註

If TRUE, Microsoft SQL Server attempts to continue processing on a partial backup or restore operation.

If FALSE, SQL Server restarts an interrupted backup or restore operation at the beginning of the backup set.

Set the Restart property only when a user action or system error interrupts backup or restore processing.

重要事項重要事項

When using the Restart property, the backup or restore operation specified by the object used must match the originally specified operation in all particulars. Do not set any other properties for the object when setting the Restartproperty.