Automatic backup of the Client Server Database

0 Likes

Problem:

How can I automatically backup up my client server database each night?

Resolution:

The FairCom server supports automatic backup of the database. The backup can be run by the system while it is carrying on normal activity and processing transactions, so it is transparent to the users. The first step is to create a backup script file.

The script file is a simple text file that consists of a series of instructions, each starting with a keyword and followed by a space and an argument. All keywords begin with an "!" and are not case sensitive. The order of the keywords does not matter, except that !FILES must be the next to last keyword and !END must be last. Some of the keywords are:

!TIME is the time of day to perform the back up. If the time has passed, then the !FREQ interval is applied to find the next scheduled time.

!FREQ is the hours between successive dumps.For example, use 24 to repeat the dump once a day.

!DUMP is the name of the file where the backup will be stored.

!FILES are the names of the files to include in the dump.

!END terminates the instructions in the script file. It must be placed immediately after the !FILES keyword and the list of files.

For ease of administration, the script file should be kept in the "\FairCom" server directory.

An example of a sample script is given here.

!TIME 23:00:00
!DUMP c:\tr\backup\tr.bak
!FREQ 24
!FILES
c:\tr\dbase\clumps.dat
c:\tr\dbase\string.dat
c:\tr\dbase
ame.dat
c:\tr\dbase\address.dat
c:\tr\dbase
ame.dat
c:\tr\dbase
umber.dat
c:\tr\dbase\query.dat
!END

This example would dump all the database .DAT files (located in directory c:\tr\dbase) into a backup file called TR.BAK (located in c:\tr\backup) every night at 11pm. Only the .DAT files are being backed up, since the database can be restored by running the TrackRecord rebuild utility on just the .DAT files.

Once you’ve created the script file, there are two methods that you can use to automate the backup process:


  1. Update the FairCom server configuration file using the DUMP command.

    You can add the DUMP command to FairCom's configuration file (CTSRVR.CFG) to ensure the backup is done each night.

    On the server in the "\FairCom" directory, using a text editor (such as notepad.exe) edit file:

    CTSRVR.CFG

    Add a line to the end of the file:

    DUMP <Path/name of backup script file>

    Example: If the backup file is named "trbackup.txt" and is located in the \FairCom directory, your CTSRVR.CFG file would have the following line in it:

    DUMP TRBACKUP.TXT

    Once you edit this file, you must shut down the FairCom server, delete all .FCS files from the FairCom directory, and then restart the FairCom server, in order for the changes to take effect.

    In order to have the system perform the backup periodically, you need to use the CTDUMP.EXE utility, and create a script file. The script file specifies when to perform the backup, at what interval to repeat it, and which files to include.

  2. Use the dynamic dump utility CTDUMP.EXE
    1. While the FairCom server is running, open up a DOS box start the utility CTDUMP.EXE. DO NOT run this program by double clicking on it from the Windows Explorer.It will not function properly.It must be run from DOS.
    2. Enter the password for ADMIN.
    3. Enter the full path and name of the dynamic dump script file (example:c:\faircom\trbackup.txt ).
    4. Unless you have renamed the FairCom server, leave the optional server name blank and hit <enter>

    The FairCom server then confirms that it has scheduled the requested dynamic dump.

    NOTE: TrackRecord 4.x and below is no longer supported.

    For more information on upgrading to the client/server version of TrackRecord, please contact Compuware sales at: 800-468-6342 or 603-578-8400 or via email at: Nashua.Sales@Compuware.com

Old KB# 11075
Comment List
Anonymous
Related Discussions
Recommended