.logfiles. Periodically a disk image of the database is updated. This image, which is also known as a checkpoint, is stored in
.sci2files. When checkpoint creation is executed, log files with records that the checkpoint now incorporates become redundant and thus are renamed from
.log.bakand are a subject of manual deletion. The fraction of
.logfiles that are still in work along with snapshot image files together represent a current durable state of the database.
.log.bakfiles regularly erased. In order to clean
.log.bakfiles you need to create a task in your preferred task scheduler for Windows or in Windows Task Scheduler to run
delcommand on your
.log.bakfiles. Please make sure that the created task in Task Scheduler do actually run as expected. Sometimes it will not run because the correct user privileges aren't set.
diskshadow.exe), but are not included in other Windows environments. We will use a tool that works effortlessly on all modern Windows operating systems (desktop and server). The below instruction explains how to backup the most recently available VSS snapshot of all files from a given location to another given location.
shadowspawn.exeutility from https://github.com/candera/shadowspawn/downloads. Put the utility on your machine in a globally available location, such as
Q:(the drive letter
Qmust be free, otherwise choose other letter), copy contents of
Q:\to a sub-folder in
Y:\Backupnamed after the current date and time, such as
Y:\Backup\2015-09-15_16-41-48, unmount and destroy a shadow copy. Copying is done with
robocopyutility that ships with Windows, you can use any other command, e.g. you can call your favorite incremental binary backup utility and store the result in a cloud.
%UserProfile%\Documents\Starcounter\Personal. If configurations have been done in the installer, then it might reside somewhere else. In that case, it can be found by following the
Program Files\Starcounter\configuration\Personal.xml, if the default setting were accepted in the installer.
Personal.server.configin this repository.
<DatabaseDirectory>. It's normally something like:
TransactionLogDirectoryand go to the path specified. There you will find the files that are necessary for backup.
.logfile in the directory, there will be no
.log.bakfiles in Windows Task Scheduler. Avoid disk overflow with
.bakfiles that you don't need! Verify that the task is actually executed as expected, since you might miss certain task settings so that Windows disallows it to run.