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