Search code examples
sqlsql-serverdatabase-backupsdatabase-restore

Backup/Restore timeout in SQL Server?


How to configure backup/restore timeout, if we are restoring from a tape or disk it might stops in the middle.

How to configure a timeout rule for it?


Solution

  • If you look at the backup syntax,there is no time out option.There is an option called continue after error,which instructs sqlserver to,not to cause backup to fail for torn pages or invalid checksums..