Solution Properties
Solution ID:
224924750069296
Last Modified Date:
Thu May 26 08:46:03 UTC 2022
Taxonomy Path:
Category//Data//Backup or restore data
Author:
LegacyAuthorUS
When using Database Administration to make a backup, where are the backups stored in Sage 100 Contractor (SQL) version 20 and later?
Description
Cause

Backup procedures

Resolution
[BCB:5:Third-party support:ECB]

  • The default location for the backup is: C:\Sage100Con\Backup
  • Instead of changing the default location, you can add a secondary backup location where the nightly backup is copied to a secondary file. See Related Resources down below for the steps on how to set up a secondary backup location.

To change where the backups are stored (change default backup location):

  1. Open up Database Admin
  2. Advanced Settings
  3. Advanced Backup Settings
  4. Browse out to your desired backup folder location

***Make sure to have this folder included in your nightly backups

Note: The nightly backups cannot be designated to go to a OneDrive for the nightly schedule. It can have it as the Copy To location after it first completes in the nightly folder, but keep in mind it will have no retention plan so will fill up your OneDrive space quickly. The Copy To location can be set in Database Administration--Advanced Settings--Advanced Backup Settings.

DocLink: How can I save a copy of my nightly database backups to another location besides a local hard drive?

Steps to duplicate
Related Solutions