How to: 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.
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
Concepts
Performing a Complete Database Restore (Full Recovery Model)
Performing a Complete Database Restore (Simple Recovery Model)