How to back up/restore the Acctivate Database.

Backing up your company’s data should be a daily business activity. It is very important to backup and safeguard your Acctivate and QuickBooks data each day and to move this information to a safe location off site.

Backing up your company data can be the difference between a minor inconvenience and disaster if anything should ever happen to your server. With ransomware attacks on the rise, and the ever looming threat of failing hardware, it's always best to backup your company database and store a copy off site in case it's ever needed. This should at the very least be a weekly routine, if not daily.

Acctivate makes the process of backing up your database quick, simple and painless. Below, we'll show you how easy it is to backup your company database using our demo company "Southwestern Industries"

Need to restore the database? Click here to automatically scroll down to the restore section.

Backing up your Database:

  1. In Acctivate, click on "File" on the top menu, and then click "Backup Company"
    1. Backup-1
  2. The "Backup Company Data" window will appear. This window contains the following fields:
    1. Window 
      1. Backup File- The name of your backup file. Usually this will be Acctivate$Company.bkf but can be renamed. Renaming the file will create a new "set" of backups. The old file will be renamed allowing your new .bkf file to retain the same name as the last one.
      2. "View Sets" button- Clicking this will populate the box below with all sets in that .bkf file.
      3. Backup Description- The name of the set you're creating. For example, if you're about to import in data, you can name the set "Pre-Import" to know that that set was created before import so you can go back to it if needed.
      4. Sets- The blank box in the image is populated with the various sets of the .bkf file. The .bkf file can contain as many sets as desired so that you can rollback to whichever set is needed. We recommend no more than 10 sets to keep your backups running quick and smooth. 
      5. Backup Path- This is the path that your .bkf file is saved at. If you ever need to locate the file, you can do so by navigating to this path. This path is fixed and can only be changed with the use of Microsoft SQL Management Studio or via the use of the registry. Please refer here for more instructions.
      6. Overwrite Existing Sets- By checking this box, you're telling Acctivate to overwrite all sets with the latest backup. Please note the previous sets will be unrecoverable and support will not be able to help you. Please be sure that you want to do this.
  3. Once you click "Start Backup" you'll receive a prompt informing you that "Company [name] will be backed up to the standard backup location. Any existing backup for this company will be appended to." Click Yes to proceed.
    1. Please Note: If you have checked "Overwrite existing sets" then the prompt will say "Any existing backup for this company will be deleted"
  4. Once you approve the backup, the database will begin to backup. A green progress bar will appear letting you know the progress. Larger company databases will take longer, as will company's with more than 10 backup sets.
  5. Once the backup is completed, you'll receive a message informing you that the backup is complete as well as the path the file can be found at.

After that, you're done! Acctivate will be successfully backed up. It is highly recommended that you take that file and copy it to a safe location offsite, rather that be on OneDrive, Google Drive, or a USB drive. This will ensure that even in the event of hardware failure, or ransomware, you'll still have your backup.

Please Note: In the scenario that your data is lost, support will be unable to assist you without a backup. It is crucial that you create a backup routine and get into the habit of backing up your .bkf files offsite for safe keeping.

Did you know that you can use the Windows task scheduler to automate your backups? We have a nifty article here about that!


Restoring your database

If you ever find yourself in the case that you must restore from a backup, rather it be from a failed import, ransomware, hardware failure, etc. Restoring your database is as easy as backing it up. Below we'll demonstrate how easy that is with our demo company Southwestern Industries. In this scenario a data import went terrible wrong and now all product ID's have been renamed.

  1. Open the "Acctivate Database Maintenance" program. This program should be in the same folder as the "Acctivate" program. You can also search on the Windows Taskbar for "Database."
  2. From the Database maintenance program, click on "Database" on the top menu bar and then click "Backup / Restore." You can also hit "Ctrl+B" on your keyboard to open this.
    1. Restore
  3. Select your company from the "Company" drop down menu. 
    1. Restore window
  4. Click the "Restore" radio button to tell Acctivate that you're restoring, not backing up.
  5. If the "Backup File" is not as expected, click the magnifying glass icon to pull up file explorer so you can search for the correct .bkf file.
  6. Highlight the desired set (in our case, we're choosing "Pre-Import.)" You'll also be able to see the date and database.
  7. When ready, click on "Start Restore"
  8. You'll receive a prompt informing you "The backup file "[FILE_NAME] in the specified location will be restored to the database for Company '[NAME].' All current data will be replaced and will not be recoverable. Do you wish to proceed?
    1. Here you should verify that the file name is the correct file and the company name is the correct company.
  9. A green progress bar will appear informing you of the progress of the restore. Larger databases will take longer to restore, and the program may hang and become unresponsive. This is to be expected. Do NOT force close the app while a restore happens.

Please Note: The restore will fail if anyone is logged into Acctivate at the time, including accessing the database from external shipping applications. Please ensure all users have closed out of Acctivate and are not processing any orders in Shipping applications.

You're finished! You've successfully restored your database to a backup. You can log into your company and resume work from that previous backup now as if nothing ever happened. 

If you have any questions or if you would like to contact support, you can create a support ticket.