Export (0) Print
Expand All

Restart an Interrupted Restore Operation (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft