TechNet
Export (0) Print
Expand All

Restart an Interrupted Restore Operation (Transact-SQL)

 

Applies To: SQL Server 2016

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.

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  

Complete Database Restores (Full Recovery Model)
Complete Database Restores (Simple Recovery Model)
RESTORE (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft