This Web site is owned by Plus Computer Solutions Ltd. Plus Computer Solutions Ltd. is independent from Sage and Intacct and is not authorized to make any statement, representation or warranties or grant any license or permission on behalf of Sage or Intacct regarding any product, service or Web site content. Certain materials made available on or through this Web site are owned by Sage or Intacct and cannot be used without the prior written permission of those entities. HubSpot Test
Google
Software » Services

Accpac Accounting Software | Accpac Training

How Do I Backup Accpac?

Subscribe to our blog giving us consent to send email updates

Your email:

Search blog

Get in Touch

Phone: 604-544-PLUS (7587)
Toll-free: 1866-714-PLUS
Email: info@plus.ca

Subscribe to our E-Newsletter

Follow Us

Insights & Information regarding enterprise resource planning software from a leading industry expert.

Current Articles | RSS Feed RSS Feed

How Do I Backup Accpac?

  
  
  
  
  
  

A question that I wish more people asked me is, How do I Backup Accpac?  That question can be broken into three sections;

  • Accpac Shared Data
  • SQL Data (MSSQL, Pervasive, Oracle, DB2)
  • Customizations

Each item has its own challenges, but once a routine is established, disaster recovery can be a pleasant experience as it relates to Accpac.

The first item is Accpac's Shared Data directory. The location of the shared data directory can be located by starting Accpac, clicking on the Help menu item and selecting System Information. This can contain many things, but most critically are Accpac's licences files, as well as the SITE, COMPANY, and USER directories.   These three directories contain things like database configuration and user settings.  Simply copy or use a file system backup utility to transfer these items to your backup location.  The licence files are all easily identified by their extensions, which are either LIC or SBE depending on the edition of Accpac you own.  Ensure that you include all the licences files, as well as all the subdirectories of the SITE, COMPANY and USER directories. 

One thing to watch out for while performing a backup of these items is locked files.  Many utilities will be unable to copy files in this state, however some files can be ignored.  One example of this is the semaphor.bin file.  Don't panic if you don't get this particular file, you can live without it.  One reason files may be locked is if Accpac is running.  If you run into locked files, be sure to investigate why they were locked and try to get a full backup as soon as possible. 

The next item is the databases.  There are two approaches to this, the first and easiest is performing a database dump.  This is an Accpac function that is independent of the database engine itself and can be performed by an end-user with appropriate Accpac security rights.  The database dump tool is located in the Windows Start menu or under Administrative Tools in Accpac. 

A database dump can be scheduled, but this requires an add-on product.  The result of a database dump is a proprietary format backup of the Accpac data.  One thing to keep in mind about a database dump is that it will only include the data Accpac knows about.  If an add-on product adds data to the database without properly registering it with Accpac, then it will not be included.

The second approach to performing a back up of the database is to interact with the database engine itself.  In the case of Pervasive SQL, the files that make up the database can be copied to your backup location at the file system level.  Something to watch out for is again, locked files.  Pervasive keeps each table in an individual file and only locks files where their respective tables are in use.  If someone is logged into Accpac, there is a strong possibility they have locked files.  Most backup utilities will skip over locked files, which will create an incomplete backup.  If you restore this incomplete backup, you're most assuredly going to have data corruption, so keep an eye on your logs.

Where Pervasive SQL has many individual files that create the database, Microsoft SQL has one.  This almost completely eliminates the possibility of doing a backup by copying the database files.  You must shutdown the SQL engine, because while it's running, all the database files are locked.  Shutting down the SQL engine, even at night isn't always practical, because some applications use the wee hours of the morning to perform maintenance. 

The proper way to make a backup is to issue a command to the SQL server to produce one.  This can be done a couple ways.  For the sake of a daily backup, you can use the Agent.  The agent can be used to execute maintenance plans that among other things include backup tasks.  Unfortunately with SQL Express, however, there is no agent, as this is one of the limitations of this particular version.  To get around this, I've developed a script that can be scheduled by the Windows Task Scheduler that will create a set of backups that can be accessed without conflict by a backup utility.  This can also be done manually from the SQL Management Studio.

The last thing to consider when backing up Accpac is the customizations. There are many things that can be considered a customization, one very common example is custom Crystal reports.  In Accpac there is a UI called Customization Directories and all custom Crystal Reports should be contained with the paths outlined there.  If all the custom Crystal Reports are properly organized in these locations, then simply configure your backup software to backup those locations.  Other customizations, such as macros or 3rd party data could be stored almost anywhere, so you would have to consult the manufacturer for a proper backup procedure.

Here's another blog you might find helpful: Accpac Error: You Do Not Have a License to Use This Product!

Contact Plus for help with your Accpac and subscribe to our blog for more tips & tricks!

Comments

Can you provide me with the steps on how to backup Accpac Sage. May be I am thick in the head but I cannot follow the above. I find steps helpful if you can supply. 
 
 
 
Thank you.
Posted @ Friday, October 30, 2009 1:11 AM by Kay
Hi Kay,  
 
Can you please provide us with some contact details (Phone/Company Name) to alison@plus.ca & we would be happy to have somebody contact you to assist you with this as the steps will depend on which database engine you are utilizing.
Posted @ Friday, October 30, 2009 2:38 PM by Alison Boons
We still use accpac DOS 6.1 can someone tell us how to edit Macros when we print our batch it always shows creation date 09 how we can chang to 2010.
Posted @ Monday, April 26, 2010 10:28 AM by Dipak Gandhi
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics