Restart Property
The Restart property controls Backup and Restore object behavior when the backup or restore operation specified by the object was started and interrupted.
Applies To
Backup Object | Restore Object |
Syntax
object.Restart [= value]
Parts
object
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);
Remarks
If TRUE, Microsoft® SQL Server™ 2000 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.
Important 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 Restart property.