About backing up your company data

Routinely backing up your accounting data is essential to ensure its safety and integrity.

There are many causes for data corruption, ranging from faulty hardware to power fluctuations. While you can replace program files or computer hardware, you cannot easily replace accounting data without a backup copy.

Database Administration for Sage 100 Contractor provides a utility for backing up your company data automatically to a network location or a local folder during nightly maintenance. Creating a series of backup copies over time enables you to restore your data from a point prior to the errors, without needing to re-enter all your accounting data manually.

Important! You should store at least one copy of your backed-up data off premises or in a fireproof safe. If a burglary or fire occurs, a copy of your data is safe from harm. We strongly recommend that you routinely store backed-up copies of your data in a safe environment that is separate from your server, preferably off site.

Backing up during nightly maintenance

You use the tabs under Schedule Nightly Maintenance to schedule the time that maintenance and backup occur, as well as the number of backup copies to keep.

Database Administration saves backup copies created during nightly maintenance to the C:\Sage100Con\Backup\Nightly folder.

Important! You need to ensure that both the server that hosts your company database and the computer where the backup copies are saved are always turned on at the scheduled time.

The automated backup procedure creates a separate zipped file for each company by date. The zipped file includes the following data:

  • A backup copy of the company's SQL database.

  • All the company files.
  • The files in the Sage100Con\Common folder.

Backing up "on demand"

You can also create backup copies manually, "on demand," at any time using the Back Up Companies tab.

The default location for backup copies you create manually is C:\Sage100Con\Backup\On Demand. Database Administration also saves backup copies to this folder whenever you archive company data or delete a company.