| □ | The MKS Backup module was designed to automate the basic daily database backup process. |
| • | MKS Backup is a set of applications that will be constantly running on either one (or two) backup servers (or workstations). |
| • | The backup server will execute only one backup per day but two backups may be made by having a second backup server perform its backup at a different time of the day. |
| • | These programs will be continuously running, looking forward to determine when to execute their daily Backup at the pre-configured time. |
| • | If there is a failure within the process, and the User is running the MKSSystemEvents.exe on their computer, the MKS Backup module will notify those Users and reschedule the backup for next day. |
| • | Once the backup is triggered, it will backup the system database (MKMS.DB) and every Company database configured on the system as long as a Connection Manager setting has been established on the machine actually doing the backup. |
| • | Every database that is backed up will be compressed into a zip file, this zip file will also include the log file for each database (if applicable). |
| • | Each new day's backup will overwrite the previous day's (zipped) backup file. |
| • | The Zip file will NOT be password protected. |
| • | File protection should be end users’ responsibility. |
| □ | The MKS Backup Utility application allows you to create one (or two) Backups of the MKMS program Databases and schedule these to occur one or more times per day. |
| • | This utility allows you to send these Database Backups to a local workstation on your network, and/or to a remote web based backup service, as needed. |
| • | If you are using the Multi-Company feature, all databases will be backed up automatically as part of the process as long as a Connection Manager setting has been established on the machine actually doing the backup. |
| • | The program is usually located at C:\Program Files\MKS\MKMS\ and is named MKSBackup.exe. |
| ► | Note: Although the application may be on your C: drive, it may instead have been installed on a File Server Drive. |
If connected to a Network, ask your System Administrator for the proper drive location of the application.
| • | As recommended in Getting Started, create a shortcut for this application and place it in your MKMS folder on your Desktop for quick access later. |
| a. | Sybase 9 (Configure to communicate via TCPIP). |
| b. | Connection Manager (With entries to access the main system database (MKMS.DB) and every Company database). |
| d. | 1 (or 2) workstations to which the software may back up the database(s). |
| e. | Enough hard drive space on each workstation to cover 2 times the combined size of all the databases. |
| □ | The MKS Backup module uses 4 program files: Two for Backup itself, one for connection configuration, and one for event notifications. |
| 1. | MKSBackup.exe - This executable will be used to configure time and location for the backup process. |
| 2. | MKSBackupSrv.exe - This executable will be setup as a windows service to run continuously. |
| 3. | MKSSystemEvents.exe - This program can be executed from any workstation. |
| • | It will hide in the Tray bar. |
| • | This program is responsible for notifying the users of events generated by the service program. |
| 4. | ConnManager.exe - This application (Connection Manager) is used to configure access to all databases (including the system database (MKMS.DB). |
| ► | Note 1: It is recommended that all 4 program files be installed in the default Micro Key Millennium Series folder (normally c:\program files\mks\mkms), however they may be stored in another folder, if necessary. |
| ► | Note 2: Although the application may be on your C: drive, it may instead have been installed in the \program files\mks\mkms folder on a File Server Drive. |
If connected to a Network, ask your System Administrator for the proper drive location of the application.
| • | MKMSBackupSrv.exe should be registered as a service on the workstation configured to run the backup. |
| • | To register the service: |
| • | Start the Windows® Command prompt (type cmd from Windows® Start Menu's Run option). |
| • | Navigate to the executable folder (type CD C:\Program Files\MKS\MKMS). |
| • | Execute the application with the /Install parameter: MKSBackupSrv.Exe /Install. |
| • | Once the service is registered, it will be accessible from the Windows® Services application. |
Configuration
| □ | The MKSBackup.exe contains a single configuration screen. |
| ► | Note: In order to access this application screen, the user must log in as Admin (based on mkmsdefault database). |
Once loaded, the software will allow the User to configure to 2 different workstations.
| • | Setting up the MKS Backup application: |
MKS Backup Utility dialog
| • | Backup 1 - Enter the information that identifies the destination for your primary backup. |
| • | Server IP - Enter the IP Address of the computer from which the backup application will be run. |
| • | Start Time - Based on a 24 hour clock (where 24 = Midnight and 12 = Noon), enter the hour in which you want the backup to commence. |
| • | Last Run - This is the time that the most recent primary backup was started. |
| • | Local Path - Enter the drive and folder location where this backup will be stored. |
| • | Compress Database - To compress this backup with a Zip file compression utility, Check this box. |
| • | Backup 2 - Enter the information that identifies the destination for your secondary backup. |
| • | Server IP - Enter the IP Address of the computer from which the backup application will be run. |
| • | Start Time - Based on a 24 hour clock (where 24 = Midnight and 12 = Noon), enter the hour in which you want the backup to commence. |
| • | Last Run - This is the time that the most recent secondary backup was started. |
| • | Local Path - Enter the drive and folder location where this backup will be stored. |
| • | Compress Database - To compress this backup with a Zip file compression utility, Check this box. |
| • | Click Save ("ü") to record your MKS Backup setup entry. |
