Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Restarting Interrupted Restore Operations in SQL Server

If a restore operation is interrupted, you can restart the operation from the point of interruption. This can be useful if you restore large databases. If the restore fails near the end of the restore operation, usually, you can restart the restore operation from where it left off, instead of restoring the whole database from the start. In particular, when you restore from tapes, you can restart on the current tape, instead of on the first tape. If restore was in the redo phase (being rolled forward), no data has to be copied from the backup set.

To restart an interrupted restore operation

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.