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