123
Senior Member
File Name: Archiver
File Submitter: 123
File Submitted: 19 Apr 2012
File Updated: 19 Apr 2012
File Category: Premise
Author: 123
Contact: PM me or post in forum.
Version: 1.0
Archiver creates and maintains a 30 day archive of Premise backups.
By default, Premise automatically performs a backup after a period of time has elapsed or after a transaction. It creates up to ten backup files in the Backups folder (backup000.xdo to backup009.xdo) and then overwrites them (i.e. it never exceeds ten files).
Given an active system, it is not unusual to find that all ten backup files were created on the same day or even within minutes of each other. This means that, in the event of a (rare) failure, you cannot restore your Premise system to the previous day's state because all ten files are recent and virtually identical (and maybe even corrupted).
Archiver is designed to make a copy of a Premise backup file and store it in a separate folder (Archives). It does this every day and maintains 30 archive files (Archive0.xdo to Archive29.xdo). It automatically overwrites the 30 files so there's no danger of filling your hard-drive with archive files. It also maintains a log (ArchiveLog.txt) that lists the date, time, and file name of each archive it has created (including error messages). In addition, it logs the same information to the Windows Event Log.
Archiver is not a Premise Module but a simple script file (VBScript). It scans Premise's ten backup files and selects the largest and most recent file to use as an archive. The selected file is copied from the Backups folder to the Archives folder (Archives folder is created automatically) and renamed as ArchiveX.xdo where X is a number from 0 to 29. The number is recorded as a system environment variable (PREMISE_ARCHIVE).
Installation
Copy archiver.vbs to a folder. I suggest \Program Files\Premise\SYS\bin.
If you are running Premise on a 32-bit version of Windows there is no need to modify archiver.vbs.
If you are running Premise on a 64-bit version of Windows you must modify archiver.vbs as follows:
Open archiver.vbs with a text-editor and change this:
to this (i.e. comment out the first line and uncomment the second line):
Save the modified file.
Start Windows Task Scheduler and create a new task that executes archiver.vbs at 1:00 AM (or some other off-peak time). Ensure your Windows environment is configured to execute .vbs files and not to open them in a text-editor!
Testing
Navigate to \Program Files\Premise\SYS\bin and double-click archiver.vbs. There should be a complete absence of any activity (i.e. no error messages). To confirm archiver, did its job, look in \Program Files\Premise\SYS\Archives. It should contain an Archive0.xdo file and an ArchiveLog.txt file. Open ArchiveLog and confirm it contains a valid entry (i.e. not an error message).
Usage
Use Builder's "File > Restore from Client" command to restore from an archive file.
Click here to download this file
File Submitter: 123
File Submitted: 19 Apr 2012
File Updated: 19 Apr 2012
File Category: Premise
Author: 123
Contact: PM me or post in forum.
Version: 1.0
Archiver creates and maintains a 30 day archive of Premise backups.
By default, Premise automatically performs a backup after a period of time has elapsed or after a transaction. It creates up to ten backup files in the Backups folder (backup000.xdo to backup009.xdo) and then overwrites them (i.e. it never exceeds ten files).
Given an active system, it is not unusual to find that all ten backup files were created on the same day or even within minutes of each other. This means that, in the event of a (rare) failure, you cannot restore your Premise system to the previous day's state because all ten files are recent and virtually identical (and maybe even corrupted).
Archiver is designed to make a copy of a Premise backup file and store it in a separate folder (Archives). It does this every day and maintains 30 archive files (Archive0.xdo to Archive29.xdo). It automatically overwrites the 30 files so there's no danger of filling your hard-drive with archive files. It also maintains a log (ArchiveLog.txt) that lists the date, time, and file name of each archive it has created (including error messages). In addition, it logs the same information to the Windows Event Log.
Archiver is not a Premise Module but a simple script file (VBScript). It scans Premise's ten backup files and selects the largest and most recent file to use as an archive. The selected file is copied from the Backups folder to the Archives folder (Archives folder is created automatically) and renamed as ArchiveX.xdo where X is a number from 0 to 29. The number is recorded as a system environment variable (PREMISE_ARCHIVE).
Installation
Copy archiver.vbs to a folder. I suggest \Program Files\Premise\SYS\bin.
If you are running Premise on a 32-bit version of Windows there is no need to modify archiver.vbs.
If you are running Premise on a 64-bit version of Windows you must modify archiver.vbs as follows:
Open archiver.vbs with a text-editor and change this:
Code:
sOSType = "" ' 32-bit
'sOSType = " (x86)" ' 64-bit.
to this (i.e. comment out the first line and uncomment the second line):
Code:
'sOSType = "" ' 32-bit
sOSType = " (x86)" ' 64-bit.
Save the modified file.
Start Windows Task Scheduler and create a new task that executes archiver.vbs at 1:00 AM (or some other off-peak time). Ensure your Windows environment is configured to execute .vbs files and not to open them in a text-editor!
Testing
Navigate to \Program Files\Premise\SYS\bin and double-click archiver.vbs. There should be a complete absence of any activity (i.e. no error messages). To confirm archiver, did its job, look in \Program Files\Premise\SYS\Archives. It should contain an Archive0.xdo file and an ArchiveLog.txt file. Open ArchiveLog and confirm it contains a valid entry (i.e. not an error message).
Usage
Use Builder's "File > Restore from Client" command to restore from an archive file.
Click here to download this file