company logo

DBRestore - Restore database backup

The DBRestore server command works similar as the RestoreDB utility, but in client/server mode. It allows restoring a backup file to a database. When running DBRestore in client/server mode, the database must be available exclusive for DBRestore, i.e. no clients must access the database.

In contrast to the RestoreDB utility, the DBRestore server command does not require an option file. Instead, the administrator must know the exact location of the database on the server, which is passed as parameter to the command.

When running database restore, clients accessing the database to be restored are stopped, i.e. clients accessing the database must finish before restore or will be killed by DBRestore. During restore, it is also not possible to start new clients on the server.

The following is a short summary of DBRestore parameters and options. More details are described in RestoreDB in Database Utilities.

DBRestore server port db_path [location] [wait]

Definition: 

server - server url or IP address

port - port number for the server passed when starting the server

db_path - The database path defines a file catalog name or the database location on the server, in which case the path must be a valid server path.

location - The location is the server path where the backup file to be restored has been stored. The location must be a valid path on the server and accessible with server rights.

wait - The wait parameter allows stopping clients after a given time interval (time in seconds). When a time interval has been defined, the clients are informed, that the client will be stopped after wait seconds. When passing 0 for wait, the clients accessing the database to be restored are stopped immediately and without warning. When not passing the wait parameter, DBRestore will terminate with error when there are active clients using the database to be restored.