How to restart an interrupted restore operation (Transact-SQL)

How to restart an interrupted restore operation (Transact-SQL)

To restart an interrupted restore operation

Important  The system administrator restoring the backup must be the only person currently using the database to be restored.

• Execute the interrupted RESTORE statement again, specifying:
  • The same clauses used in the original RESTORE statement.
    
    
  • The RESTART clause.

Examples

This example restarts an interrupted restore operation:

-- Restore a database backup of the MyNwind database
RESTORE DATABASE MyNwind
   FROM MyNwind_1
GO
-- The restore operation halted prematurely.
-- Repeat the original RESTORE statement specifying WITH RESTART
RESTORE DATABASE MyNwind 
   FROM MyNwind_1
   WITH RESTART
GO

See Also

Database Backups

RESTORE

Copying Databases