RESTOREINTERVAL

The RESTOREINTERVAL option specifies how long a restartable restore session can be saved in the server database. As long as the restore session is saved in the database, it can be restarted from the point at which it stopped.

You can update this server option without stopping and restarting the server by using the SETOPT command. See SETOPT (Set a server option for dynamic update).

Syntax

Read syntax diagramSkip visual syntax diagram
                    .-1440----.   
>>-RESTOREINTERVAL--+-minutes-+--------------------------------><

Parameters

minutes
Specifies how long, in minutes, that a restartable restore session can be in the database before it can be expired. The minimum value is 0. The maximum is 10080 (one week). The default is 1440 minutes (24 hours). If the value is set to 0 and the restore is interrupted or fails, the restore is still put in the restartable state. However, it is immediately eligible to be expired.

Examples

restoreinterval 1440