Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Operations
Administration (Database Engine)
Administration: How-to Topics (Database Engine)
Backing Up and Restoring How-to Topics (Transact-SQL)
How to: Create a Full Database Backup (Transact-SQL)
How to: Use Resource Governor to Limit CPU Usage by Backup Compression (Transact-SQL)
How to: Restore a Database Backup (Transact-SQL)
How to: Restart an Interrupted Restore Operation (Transact-SQL)
How to: Create a Transaction Log Backup (Transact-SQL)
How to: Back Up the Transaction Log When the Database Is Damaged (Transact-SQL)
How to: Apply a Transaction Log Backup (Transact-SQL)
How to: Create a Differential Database Backup (Transact-SQL)
How to: Restore a Differential Database Backup (Transact-SQL)
How to: Recover a Database from a Backup Without Restoring Data (Transact-SQL)
How to: Restore to the Point of Failure (Transact-SQL)
How to: Restore to a Point in Time (Transact-SQL)
How to: Restore the master Database (Transact-SQL)
How to: Back Up Files and Filegroups (Transact-SQL)
How to: Restore Files and Filegroups (Transact-SQL)
How to: Restore Files and Filegroups over Existing Files (Transact-SQL)
How to: Restore Files to a New Location (Transact-SQL)
How to: Restore a Database to a New Location and Name (Transact-SQL)
How to: Enable or Disable Backup Checksums (Transact-SQL)
How to: Specify Whether BACKUP Continues or Stops upon Encountering an Error (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Restart an Interrupted Restore Operation (Transact-SQL)

SQL Server 2008 R2

This topic explains how to restart an interrupted restore operation.

To restart an interrupted restore operation

  • 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.

Copy 
-- Restore a full database backup of the AdventureWorks2008R2 database.
RESTORE DATABASE AdventureWorks2008R2
   FROM DISK = 'C:\AdventureWorks2008R2.bck'
GO
-- The restore operation halted prematurely.
-- Repeat the original RESTORE statement specifying WITH RESTART.
RESTORE DATABASE AdventureWorks2008R2 
   FROM DISK = 'C:\AdventureWorks2008R2.bck'
   WITH RESTART
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.