ALTER DATABANK RESTORE
Restores a databank from a backup of
LOGDBor from the information currently in
This form of
ALTER DATABANKis used to recover a databank in the event of it being damaged or destroyed. You can use this SQL statement to restore the databank from information contained in the log records for the databank held in the current
LOGDBor from a
LOGDBbackup. Refer to of the Mimer SQL System Management Handbook, Backing-up and Restoring Data, for details on Backup and Restore.
Before using the
ALTER DATABANK RESTOREcommand a valid backup copy of the databank must be copied in place.
The recovery operation must start from a usable backup copy of the databank file, which has been created using the host file system backup or from a backup taken using
Once the restored databank file is in place,
ALTER DATABANKis used to bring the databank up to date by applying any updates made to it since that copy of the databank file was taken. The updates may have been recorded in one or more backups of
LOGDBand the latest updates will be contained in the log records in the
LOGoption is used, the updates for the databank recorded in the log records currently in
LOGDBwill be applied to the databank.
Note: The timestamp information contained in both the databank file and the LOGDB records must match, otherwise a backup sequence error is returned.
filename-stringis specified, it names a backup
LOGDBfile. The updates contained in the file will be applied to the databank. Note that the timestamp information contained in both the databank file and the backup file must match, otherwise a backup sequence error is returned.
Only the creator of the databank or an ident with
SYSADM), may use the
ALTER DATABANK RESTOREstatement to restore it.
If the databank does not have
LOGoption, there will be no operations recorded in
It is possible to restore a databank that has been set offline.
The recovery operations performed using
ALTER DATABANK RESTOREcan only be applied to a copy of a databank file which has been placed in the original file location used by the databank.
If the copy of the databank file must be restored to a new location for some reason (e.g. a disk has been lost), then
ALTER DATABANKis first used to change the databank file location.
ExampleALTER DATABANK usrdb RESTORE USING 'usrdblog'
For more information, see the Mimer SQL System Management Handbook, Backing-up and Restoring Data.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40