This documentation is archived and is not being maintained.
How to: Restart an Interrupted Restore Operation (Transact-SQL)
This topic explains how to restart an interrupted restore operation.
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