Export (0) Print
Expand All

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

SQL Server 2000

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft