Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Restart an Interrupted Restore Operation (Transact-SQL)

This topic explains how to restart an interrupted restore operation.

To restart an interrupted restore operation

  • Execute the interrupted RESTORE statement again, specifying:

    • The same clauses used in the original RESTORE statement.

    • The RESTART clause.

This example restarts an interrupted restore operation.

-- Restore a full database backup of the AdventureWorks database.
RESTORE DATABASE AdventureWorks
   FROM DISK = 'C:\AdventureWorks.bck'
GO
-- The restore operation halted prematurely.
-- Repeat the original RESTORE statement specifying WITH RESTART.
RESTORE DATABASE AdventureWorks 
   FROM DISK = 'C:\AdventureWorks.bck'
   WITH RESTART
GO

Community Additions

ADD
Show:
© 2015 Microsoft