Restart an Interrupted Restore Operation (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic explains how to restart an interrupted restore operation.

To restart an interrupted restore operation

  1. Execute the interrupted RESTORE statement again, specifying:

    • The same clauses used in the original RESTORE statement.

    • The RESTART clause.

Example

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  

See Also

Complete Database Restores (Full Recovery Model)
Complete Database Restores (Simple Recovery Model)
RESTORE (Transact-SQL)