# Backup

It is very important to take a backup of the database at regular intervals. This ensures that no data is lost in the event of any unforeseen circumstances like machine failures, disk crashes, database crashes etc. The Backup option makes a copy of database that can be used in future.

The last three backups taken will be maintained by the system.

When the question "Ready for taking backup?" is displayed, click Yes to proceed.

On confirmation, the message "Backup process in progress…" is displayed.

On completion the message "Backup completed successfully" is displayed.

A copy of the database is made in the Backup directory. The name of the Backup database will be the current date appended to the database name e.g. Proqms2-27-May-2003.

For Access Database : The database name will have the extension .mdb

For Oracle Database : The database name will have the extension .dmp. The logfile will also be created in the same directory with the same database name and extension .log. You can view the contents of the logfile to check the status of the backup process.

For SQL Server Database: Backup will be taken on the server in a backup device. The name of this device will be the current date appended to the database name. This will be created on the server machine itself. You can view the device from the Enterprise manager on the server. This file can be transferred to Detachable storage devices manually. For every backup a new device will be created.

If you attempt to take a backup on the same date more than once, the question "Backup already taken, do you want to over write it?" is displayed. Click Yes to overwrite the backed up database. Clicking on No displays the message "Backup canceled".

See Also : Restore