SOX Backup Express for Sage 300
SOX Backup automates 2 processes critical to a well-run Sage 300 (Accpac) installation: DBDump and Data Integrity Checking. Multi-day DBDump archives are managed automatically. There are options to include the backup and management of Sage CRM or any other SQL Server database. The DBLoad process can also be automated, where appropriate for an installation. SOX Backup is designed to run as a Windows Scheduled Task without user interface pop-up windows, producing a log file and providing email notification. Archives can be copied to an offsite FTP location.
For users of Microsoft SQL Server Express Edition, SOX Backup Express provides a scheduled way to back up data onsite, as the Job Scheduler function of SQL Server Standard Edition is not included in SQL Server Express Edition.
Settings are stored in an XML file that drives Windows Scheduled Tasks, a core o/s, always-on service. A headless design means jobs cannot get hung up waiting for user responses. Multiple XML files can drive multiple jobs.
Any number of Sage 300 databases can be backed up into or restored from a single archive. DBDump format is many times smaller than database backup formats and removes indexes and possible index corruptions.
The Accpac shared folder and matching databases are backed up into a single archive. Between 1 and 99 daily archives can be managed with automatic cycling – at limit, oldest is automatically removed. Archive management helps avoid disk full conditions.
Application level integrity should be checked on a regular basis. Database integrity checks database structure, not application integrity. The SOX Backup summary assists analysis by distinguishing errors from warnings.
Data can be reliably copied offsite, using robust re-try strategies – exponential backoff with configurable limits. Archive file splitting sizes are configurable to accomodate internet connection quality.
SQL Server Databases
CRM, Sales Analysis or eRequester database backups are stored in a daily archives. Any number or kind of SQL Server databases can be included. Provides an automated backup mechanism for SQL Server Express users.
Email subject line includes SUCCESS, FAIL or NOTE status. Email body is a copy of the log file. If internet connectivity is lost, emails are re-tried using FTP settings and mechanisms. Does NOT rely on Outlook, Exchange or ISP mail servers.
Monitor jobs that did-not-run, because of password or rights changes. TaiRox monitoring service notes the absence of any expected message. Monitoring can be set up for use by TaiRox or business partner or both.
A log file is stored with the daily archive, either summarized or detailed. The server name, local server times, disk-space usage and other tracking data is logged. Data integrity warnings and errors are distinguished in the log summary.