Backing Up a Company Database

Database Administration for Sage 100 Contractor provides a utility for backing up your company data to a network location or a local folder automatically, according to a nightly maintenance schedule.

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

IMPORTANT:  Always use Database Administration to back up your data. Database Administration backs up numerous files (including external files, such as attachments) that are not part of the SQL database, and it performs additional steps to ensure that you can successfully restore your data from a backup copy. Do not attempt to back up Sage 100 Contractor data using Microsoft SQL Server Management Studio or other third-party software, or you will be unable to restore the company.

Before backing up

IMPORTANT:  Ensure that both the server that hosts your company database and the computer where the backups are to be saved will always be turned on at the scheduled time.

To back up a company "on demand"

1. Click Tune Up / Back Up / Restore > Back Up Companies.
2. In the grid on the tab, select the check mark beside each company you want to back up at this time.

3. If you want to store the backup file in a different location than the default folder (C:\Sage100Con\Backup\On Demand), browse to and then select the backup folder you want to use.

   TIP:  If the folder does not yet exist, you can make a new folder.

4. Click [Create Backup].

After backing up

Consider copying your backed-up data to additional media for off-site storage or to another network location, in case of fire or a burglary at the location where you keep the computer that runs Sage 100 Contractor. For more information, see Backing up your data to a CD or DVD.