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

title	Restart interrupted restore (Transact-SQL)
description	This example shows you how to restart an interrupted restore operation in SQL Server using Transact-SQL.
ms.custom	seo-lt-2019
ms.date	12/17/2019
ms.prod	sql
ms.prod_service	backup-restore
ms.reviewer
ms.technology	backup-restore
ms.topic	conceptual
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
author	MikeRayMSFT
ms.author	mikeray

Restart an Interrupted Restore Operation (Transact-SQL)

[!INCLUDE SQL Server] 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)