background image

Ice Ledger

Data Backup / Restore


Utilities Menu   Watch Backup Video on Youtube
Watch Backup Video on Youtube

Data Backup

To backup your company data, select Backup Data from the Utilities menu to open the Backup screen. On a multi user / network setup, a message in red is displayed: NOTE: Login function has been disabled, other users are NOT allowed to login.

Data Backup
 

The system automatically generates a backup file name based on your backup file naming template in settings (Settings / Configurations / Company / Auto). Use the button with 3 dots, to the right to select the drive and folder where you would like the backup file to be saved.

Description. You can add a short description for your backup.

DB Server Local Folder (Shared). This is the folder on your server that is shared on your local network. If you are using a stand alone system, then this can be any folder with write permissions. This can be set in system settings (Settings / Configurations / Workstation - Database Server Shared Folder).

Path to Server Shared Folder. This is the folder path on your network that referrs to the shared folder on your server i.e. networ path to the above folder on the server. On a stand alone system, this MUST be the same as the folder listed above. Both of these folders can be defined in system settings. This can be defined in system settings (Settings / Configurations / Company / General - Server Shared Folder).

Once the above 2 folders have been set correctly, you can click the Backup button to start the backup process. Once the initial part of the backup process (making a copy of the company data) has completed, other users are allowed to login and the abobe message, in red, disappears. During the second stage of the backup, the data and other associated files are archived (compressed) in to a single backup file.

If you have defined a separate text file containg a list of additional files that should be included in the backup (see below), then the name of the file will be shown on the screen.

Details of the backup progress is listed in the lower part of the screen, including summary details of previous backups.

Security

If you wish to password protect your backup archive file, you can enter the password in the system settings (Settings / Configurations / Company / General - Backup Code). With this being set in system settings, means that the actual person delegated to carry out the backup need not know what the actual backup password is. Please take care that you do not forget the passoword, especially if you have to go back to it after a long period. It may be advisable to also add a password reminder hint.

Backing Up Additional Files

You can get the system to include additional files to be backed up by creating a text file, containing a list of files to be included in the backup, and defining its location in Settings, Configurations, Workstation. A sample text file is listed below.

; Ice Ledger Sample Back Up Files List
; Blank lines and lines beginning with a semi-colon (;) are ignored
; List each entry as a comma separated list of GroupName, FilesList
; Avoid using the following Group Names: App, Data, Layouts, Logs, Logs_WrkStn, Shared, Templates

Batch, C:\SW\*.bat
Batch, C:\Data\*.bat
SpreadSheets, C:\Data\*.xls
SpreadSheets, C:\Data\*.xlsx
Docs, C:\Data\*.doc
Docs, C:\Data\*.docx

; A files list can also be a folder - ending with a back slash (\)
; When specifying a folder then you can also specify a single exclude e.g. exclude .zip files
Project, C:\ProjectX\, *.zip

Prg, K:\Dev\SCB\*.prg
Scans, C:\Scans\,*.jpg
  

Blank lines and line beginning with a semi-colon are ignored. Each file list entry must be on a separate line and you can use the standard file related wild cards (? = any character and * = any one or more characters). Each line is a comma-separated line with the following structure:

Un-Attended Data Backup

You can run Ice Ledger using a batch file and pass additional parameters so that the system logs in and starts the backup process unattended. The batch file can then be scheduled to run when the system is not in use to perform an unattended backup. To setup an unattended backup, follow the guidelines, listed below:

Below is an example of a batch file command required to carry out an unattended backup:


Once the data backup has been completed, the system sends a confirmation email to the email address specified in the system Configurations, Company, General, Email Data Check. The system attempts to send the email directly to the recipient mail server. However, if this fails the the system sends the email using the mail server details in the system settings (Configurations, Email).


If the option to check the data is set then a separate email will be sent to the same email address.

Data Restore

WARNING: If you select to restore data, your current company data will be DELETED and replaced with the data from the backup. This process is NOT REVERSABLE. Consider making a backup of your data before continuing with data restore.

Select the option, Restore Data from the Utilities menu. Using the button with 3 dots, select the backup file (*.bak, *.ice, *.sas) containing the data you wish to restore. The system will then display detail from the backup file, above the selected file name.

Once you have selected the correct backup file, you can tick one of the options, below the file name, to enable the Restore button on the toolbar, above.

To resore the company data from the backup, you must tick the Restore Data option. You do NOT have to restore the company data to restore other files in the backup archive. If you tick any other options, then the option to restore these additional files to a Different Folder is displayed. Checking this option will further display an another field to select the folder where these files should be restored to.

Once you have check the resuired options, click the Restore button, on the toolbar, to start the data restore process.

Data Restore
 

 
 

Follow Us on Facebook  Follow Us on Twitter  Follow Us on YouTube
Copyright © 2014 - 2022 1T Solutions Limited. All Rights Reserved.