restart-an-interrupted-restore-operation-transact-sql.md

title	Restart an Interrupted Restore Operation (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	dbe-backup-restore
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	interrupted restore operation restoring databases [SQL Server], restarting interrupted operation resetting options changed after backup database restores [SQL Server], restarting interrupted operation restarting interrupted restore operation restoring interrupted operation [SQL Server]
ms.assetid	6413a07d-fd90-448d-8f29-12c5a1972618
caps.latest.revision	24
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

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

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