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

  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

Concepts

Performing a Complete Database Restore (Full Recovery Model)
Performing a Complete Database Restore (Simple Recovery Model)

Other Resources

RESTORE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance