When using Database Administration to make a backup, where are the backups stored in Sage 100 Contractor (SQL) version 20 and later?

Summary

Where are backups in v20 stored? Where are nightly backups saved? Default backup location Where is my backup folder? Backups Can I change where backups are stored?

Cause

Backup procedures

Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

  • 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?

Solution Properties

Solution ID
224924750069296
Last Modified Date
Thu May 26 08:46:03 UTC 2022
Views
0