Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Restarting Interrupted Backup and Restore Operations

SQL Server 2000

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

Transact-SQL

SQL-DMO

To restart an interrupted restore operation

Transact-SQL

SQL-DMO

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.