How to restart an interrupted backup operation (Transact-SQL)

How to restart an interrupted backup operation (Transact-SQL)

To restart an interrupted backup operation

• Execute the interrupted BACKUP statement again, specifying:
  • The same clauses used in the original BACKUP statement.
    
    
  • The RESTART clause.

Examples

This example restarts an interrupted database backup operation:

-- Create a database backup of the MyNwind database
BACKUP DATABASE MyNwind
   TO MyNwind_1
-- The backup operation halts due to power outage.
-- Repeat the original BACKUP statement specifying WITH RESTART
BACKUP DATABASE MyNwind
   TO MyNwind_1 
   WITH RESTART

See Also

BACKUP

Database Backups