From Sage Install Guide: 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.
By default, when you create a new company through the Database Administration tool, it will automatically set up two weeks of backup retention. You can also change the retention period by going through the "Schedule Nightly Maintenance" tab. These locally kept Sage backups will be the quickest way to recover a clients company file, and will require no intervention from Swizznet. For this reason, we suggest that you keep the default two weeks of retention.
By default, the copies will be kept at this location: D:\Sage100Con\Backup\Nightly on servers with an additional data drive. Otherwise they will be kept here: C:\Sage100Con\Backup\Nightly. When Swizznet's nightly backup process runs, we will also make another backup of these files and keep the last 30 days of backups. Clients in our Google data center will need to copy the backups to the c:\data\companycode\* directory if you would like them captured by our nightly backup system.