Scheduling a Daily Database Backup

Note: The following procedure uses a Microsoft Windows utility that was current at the time of this writing. Your process may be different. Please refer to your operating system’s documentation for scheduling a backup.

To schedule a database backup:

  1. Log on as the database administrator (DBA) to the machine where the database resides.
    Note: You can determine the DBA by opening a command prompt and entering dbuser -list sqmdb.
    Using the incorrect account could result in a backup file that contains incorrect or no data.
    Note: The user name is case sensitive and must be exactly the same as used when the database was created. The install utility created a directory called \Caliber_Backup in the root of the drive where you installed the server. This is the default (preferred) location for the backup file.
  2. Select Start > Programs > Command Prompt .
  3. Create a text file named BackupCaliber.cmd that contains the line:

    dbmgr -backup drive:\Caliber_Backup\SQMDB.bak

    substituting “drive” for the drive where the Caliber server is installed

  4. Save the file in the \Caliber_Backup\directory that was created during installation.
  5. Open the Control Panel.
    • Double-click the Scheduled Tasks icon.
    • Double-click the Add a Scheduled Task icon.

    The Scheduled Task Wizard dialog box is displayed.

  6. Click Next. The second Wizard screen is displayed.
    • Click Browse and navigate to C:\Caliber_Backup, or wherever the server is installed.
    • Select BackupCaliber.cmd.
    • Click Open.
  7. Click Next. The third Wizard screen is displayed. Select the Daily option button and click Next . The fourth Wizard screen is displayed. Set the Start time , select the Every Day option button and set the Start date .
  8. Click Next. The fifth Wizard screen is displayed. Enter the Database user name of the Caliber database and the password.
    Note: The vbackup utility and any scheduling software must be run under the account of the user that created the SQMDB database.Vbackup will create an SQMDB file under non-creator accounts, but the sqmdb.bak file will contain invalid data and cannot be restored.
  9. Click Next. The last Wizard screen is displayed. Review the screen and click Finish to complete the addition of the task, or Back to make any changes. The task should now appear in the Scheduled Tasks directory.