This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The Restart property controls Backup and Restore object behavior when the backup or restore operation specified by the object is started and interrupted.
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 Restart property.|