Restarting Interrupted Backup and Restore Operations

Administering SQL Server

Administering SQL Server

Restarting Interrupted Backup and Restore Operations

If a backup or restore operation is interrupted (for example, if the power fails), you can restart the backup or restore operation from the point at which it was interrupted. This can be useful if you restore large databases onto other servers as an automated process. If the automated process fails near the end of the restore operation, you can attempt to restart the restore operation from where it left off, rather than restoring the whole database from the beginning.

To restart an interrupted backup operation